Have you ever wanted to completely rearrange the data you have in Excel so that your rows become columns and your columns become rows? Maybe you receive data that’s not formatted the way you need it or maybe you just changed your mind about how you want a spreadsheet arranged. Either way, Paste Special – […]
Archive for category General Tips
Have you ever tried to copy numbers from one spreadsheet to another, only to discover that the cells you copied actually contained formulas? When you pasted them into the new location, each cell had an error instead of the number you wanted. Here are 3 different ways you can convert a formula into the number that is the result of that formula.
Excel – Worksheet Protection
Nov 11
If you want to keep part or all of a spreadsheet from being changed, you need Excel’s worksheet protection feature.
Most Excel users know how to use the SUM function to get the total of a group of numbers. But did you know that Excel also gives you the ability to total just the numbers that meet your conditions?
Excel’s IF FUNCTION
Sep 30
If you what you want to display in a cell on a spreadsheet, or if the formula that you use needs to vary depending on the contents of a different cell, then the IF function is just what you need.
Data validation may sound complicated, but it’s just a way to apply rules to a cell to make sure good (valid) data is being entered. How can you use this? You can set data validation for a cell to only accept a certain type of data such as date, time, numbers, or whole numbers. You […]
It’s always important to know the relationships and dependencies between cells on your spreadsheet. If you edit a cell, which other cells will be affected? And which cells does a particular formula look to? Both questions are easily answered with the Trace Dependents and Trace Precedents buttons. To find out which cells/formulas refer to (are […]
This is the last in a series of tips related to the Excel’s Subtotal feature which automatically inserts subtotals and grand totals into a list and groups the rows into a collapsible outline. Auto sum only works in certain situations. When it doesn’t work you can still accomplish the same thing with just a little […]
First, to clear up any confusion, I’m talking about the Subtotal function, not the feature. A function in Excel is a command used in writing a formula. The Subtotal feature automatically inserts It subtotals (using the subtotal function) into a table of data. Now I know it sounds strange that the SUBTOTAL function in Excel […]
You’re probably thinking “of course it’s easy, just copy it.” But sometimes you have data laid out like the example below. The customer name and sales rep have only been entered when the data changes. This way they act like headings and make the report easier to read. But if you want to sort this […]
