Excel 2007 articles
A very cool shortcut you can use in Excel 2007 allows you to copy data from the cell above the current cell. Follow the steps below to learn how: Click Ctrl + “ (quotation mark) Say you enter the number 456 in cell A6. If […]
How to Quickly Enter Similar Data in an Excel 2007 Worksheet Read More »
While working on a spreadsheet the other day I had difficulty getting zeros to show in a column of zip codes even though the numbers were formatted as zip codes. I’d never had this problem before, but it was somebody else’s worksheet. There are several
If you have a very large worksheet containing rows and rows of data it would be a lot easier for you if you were able to freeze both the top and bottom rows of your worksheet. Unfortunately, there is no way to do this in
Once you have your ribbon customized perfectly and want everyone else to have the same, it’s a very easy task to share with your colleagues. Follow the steps below to learn how: Right-click your Ribbon and select Customize the Ribbon. Just below the the list
You may have an occasion when you would like to copy cells from your current workbook to a new one. Fortunately, this is very easy to do. Follow the steps below to learn how: Close all open workbooks except for your current on and the
Folks define names in their Excel worksheets all the time and they can sometimes end up with so many names that they have difficulty remembering them or finding them! Of course, you can can jump to a named range by clicking on F5 to open
Lots of businesses have data tables set up in worksheets but this tip is not just for businesses. Say you have a large business and have set up a data table of your clients. In the first column you have the name of your clients
There are lots of instances where you would like to delete every second, third, fifth, etc. rows in your worksheet. One instance that readily comes to mind is when you use data from another source. Luckily this is not a difficult task! Follow the steps
Have you ever had a need to use conditional formatting in a row in your worksheet? Suppose you need to highlight all the values in your row that exceed a certain number. I had a client call me regarding this issue not too long ago.
There are two ways to work with dates in Excel, the hard way where you do all the work or the easy way where Excel does all the work for you. If you work with monthly sheets e.g. Jan, Feb, etc. then this tutorial may
As you most likely already know, when you create a chart in MS Excel, it will automatically create a chart legend for you, depending on which type of chart you have created. You are not, however, limited to using that particular legend. You do not
When the information in your worksheet will not fit on a single page, Excel will break it up for you at row and column boundaries, and then it will print your data on multiple pages. You cannot control the order in which Excel will pring
Some folks are not aware that there are several kinds of underlines available in Excel that you can use within your cells. Follow the steps below to learn how: Display the Home tab of your Ribbon. In the Cells group, click the down-arrow under Format
There is an interesting function in Excel worksheets. I know that you are most likely thinking – well most of them are pretty interesting, but this particular function is interesting in that it makes sure that your text is clean. What do I mean by
