Here's a nifty way to delete all values entered into a workbook while keeping the formulas.

• Open the Excel worksheet containing the values and formulas.
• Hit "Ctrl G", that will bring up the Go To dialog box

• Click on "Special"
Average:
4
I Averaged: 4 | 2 votes

When you're highlighting entire rows or columns in MS Excel that don't start from the top, Excel actually will let you know how many have been selected as you go. Notice 9R in the image below, indicates 9 rows have been selected.

While working in Excel, often times there's a need to use a calculator, here's a way to add one to your toolbar in Excel 2007.

First, right click on the toolbar and choose "Customize Quick Access Toolbar".

On the next Excel Options screen choose "Commands Not in the Ribbon" from the "Choose Commands From" drop down menu.

For those of us who use MS Excel there are a lot of times you may want to have report headings centered across the top of the page. The only way you used to be able to do this was to use the Merge and Center option. Although Merge and Center serves its purpose, it can cause other problems down the road, such as selecting ranges or copy and pasting ranges.

Since yesterday when I go to open a folder or file, they are all showing in reverse alpha order. They are all showing with the letter Z first and going backwards, it's driving me crazy, how do I get it back to the way it was with A showing first?

If you have a spreadsheet that has variable decimal places and need to align them in a column on the decimal point regardless of the number of digits before and after the decimal, here's how:

Decimals not aligned:

Here's how to clear the list of recently used files in MS Office 2007 (Word, Excel, Powerpoint).

Go to the Office Button, choose the Word/Excel/Powerpoint options button in the lower right hand corner.

In that dialog box go to "Advanced". Scroll down to "Display" and where it says "Show this number of recent documents" set the number to 0 then hit OK.

So have you ever had your F2 editing button stop working? (I use mine a lot for editing cells in Excel). For the longest time mine had stopped working and well I had just given up on it. Now I've realized that there is an F Lock key so I just pressed it again and there ya go, my F2 is working again!! Woot!