Skip to content

How To Excel At Excel

Search
  • Blog
  • Formula Friday
  • Macro Mondays
  • Formulas
  • Excel Tips& Tricks
  • Excel Charting

Category: Excel Tip Category

link to Eliminate (or reduce) Errors by Using Your Own Auto Correct.

Eliminate (or reduce) Errors by Using Your Own Auto Correct.

Here is another time saving tip for you today, Excel not only has autocorrect, but you can instruct it to insert the correct words for you, even if you shorten them to a few letters, to save time...

Continue Reading
link to Create A Custom And Re-Usable View of your Excel Worksheet

Create A Custom And Re-Usable View of your Excel Worksheet

I like to cut down on actions that constantly require you to manualy repeat them.  I like to do things once, then just re-use the process of possible.  That is why this is such a great time saving...

Continue Reading
link to How To Display a Plus + Sign On Positive Numbers With Custom Formatting In Excel

How To Display a Plus + Sign On Positive Numbers With Custom Formatting In Excel

Most Excel users would be used to working with the concept of displaying negative numbers in a worksheet with a preceding - sign in front of the number, something a bit like this below, where I have...

Continue Reading
link to Excel Tip – Flag Your Excel Document As Final Version

Excel Tip – Flag Your Excel Document As Final Version

In Excel (and other Office Documents) did you know you can mark your workbook as Final?.  If you have finished work on your workbook, you can discourage any further editing by users by using this...

Continue Reading
link to Excel Tip -Transform Dates To Be More User Friendly

Excel Tip -Transform Dates To Be More User Friendly

I download a lot of data form various sources, so the quality and formatting of it can vary significantly.  One issue that occurs a lot of the time is a date field being formatted as text.  It...

Continue Reading

Excel Tip- How To Make cell value formatting stick in a Pivot Table

I have seen this a lot with Pivot tables, the frustration of Excel users when they format their data in a Pivot Table, but they hit refresh or they remove and add back data into the calculations area...

Continue Reading
« PREV Page 1 … Page 6 Page 7 Page 8 Page 9 NEXT »

© 2025 Copyright How To Excel At Excel