I have many students that ask me how to create a list of the most used Excel Formulas. There are a few ways...
If you want a list from Microsoft Help, just open your help by pressing F1 or use your Office Assistant. Search for Formulas and Print the Help page.
But sometimes this list isn't entirely what you want. So, you can simply create your own list of formulas and print your list for future reference.
To do so, follow these instructions.
Type a list of the common formulas you use (or use an existing spreadsheet that someone else has created).
Click Tools | Options.
Click on the VIEW Tab.
On the View Tab, check "Formulas" in the Windows Options area of the Tab.
Click OK and you will return to your spreadsheet with the Formulas showing, instead of the results.
It's that simple.
Sunday, February 28, 2010
Monday, February 1, 2010
Here's the link to the latest Go Ask Debbie Newsletter. With Go Ask Debbie, you'll find training and tips on many popular computer software programs, such as Microsoft Word, Excel, Outlook, PowerPoint, Intuit QuickBooks, and more!
I often hear people say "I no longer see the Forward, Reply, and Reply to All buttons on my emails. How do I get this information back?...
Since 1998, Google has been giving us Google Doodles. The first Google Doodle was in honor of the Burning Man Festival . It wa...
This is the text version of a YouTube Live session of Go Ask Debbie: How to Delete Blank Rows in Excel. I thought I'd just do a quick ...