Microsoft Excel articles
The Formula Bar resides at the top of your Excel window, immediately below the Ribbon area or the Formatting toolbar depending on which version of Excel you own the license to. There are two parts of the Formula Bar: On the left-hand side is the […]
How to Hide the Excel 2010 Formula Bar Read More »
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
How to Freeze Top & Bottom Rows in Excel 2010 Read More »
If you have the need to move or copy a worksheet from one workbook to another it is very easy to do in Excel 2010. You can use the Move or Copy dialog box to accomplish this task very easily and smoothly. Follow the steps
How to Copy or Move Worksheets to other Excel 2010 Workbooks 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
Getting Zeros to Show in Excel Read More »
I use Excel spreadsheets as my data files in most mail merges with Word because the process is easy and seems to work seamlessly, but I’ve worked mostly with textual data. The first time I worked with currency values, I had problems getting the dollar
Getting Excel’s Currency Symbol to Show in Mail Merges Read More »
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
Freezing Top and Bottom Rows in MS Excel Read More »
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
Share your Customization in MS Excel Read More »
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
Copy and Move Cells to New Workbook in MS Excel Read More »
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
I Know I Put That Name Someplace! Read More »
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
Count With Pivot Tables in MS Excel Read More »
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
Delete Every Other Row in your Excel Worksheet Read More »
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.
Using Conditional Formatting in MS Excel Read More »
Did you know that you can add diagonal borders to the cells in your Excel worksheet? Well you can! You can put border on the right, left, top, and bottom of your cells. If you select a range of cells, you can even add those
Add Diagonal Border in MS Exel Read More »
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
Working With Dates in Excel Read More »
