Microsoft Excel autumn tips digest

Here you will find some handy Excel tips and tricks

Whether it is complexity or simplicity of Excel that makes you read about it, this application is still a great tool for calculations, tracking data  and such. So today we are offering you a digest of the handiest (in our opinion) Excel tips and tricks that have been out since mid-October. We rummaged through the endless world of articles and here you go! Hopefully this information will help you boost your Excel experience and save some of your time.

Now where on the network did I save my workbook?

If this question bugs you as well, look at this article to learn how to add the Document Location box to the Quick Access Toolbar.

Quickly fill blank cells in a table

When blank cells don't let you process your data correctly, you should study this tip which shares a solution for filling blank cells in your spreadsheet.

Fill formula to last used row

Check out a quick one to learn about filling formula to the last used row.

Tip: You can convert your range with data into Excel table by pressing Ctrl+T in Excel 2007-2010 and Ctrl+L in version 2003. Then your formula will be automatically copied to all cells. You can read even more about it in our article Excel Table vs. range - which is better?

How to enter the same value on multiple sheets (or in multiple cells at once)

Here you'll find the answer to a user's question about entering the same formula on several worksheets in Excel.

Two tips for faster worksheet navigation from Excel blog

Last but not least, if you still find it tricky to simultaneously work with multiple worksheets in Excel, invest some time in reading this trick on Excel blog.
If you often work with several books you might also appreciate our Workbook Manager add-in which allows easy navigation between your worksheets and workbooks, insert, rename, delete, sort them in a click and more.

That's it for now. We are going to keep you informed on the latest MS Office news, updates, tips and tricks. Next time you will have a chance to learn more about Outlook. See you!


Post a comment

Unfortunately, due to the volume of comments received we cannot guarantee that we will be able to give you a timely response. When posting a question, please be very clear and concise. We thank you for understanding!
Excel add-ins and Outlook tools -
Ultimate Suite for Excel Professionals
60+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Sheila Blanchard