Tips & Tricks

You know that Microsoft Excel is a handy program for accomplishing all sorts of tasks. Now, get the scoop on neat little tricks you may not know about. While they probably won't change your life, they'll definitely enhance your productivity.

  • Create an Instant Chart You can create a chart quickly in Microsoft Excel without having to use the chart button on the toolbar by using these two shortcuts whilst inside a range of data ...
    Posted Apr 2, 2011, 8:43 AM by Ayush Jain
  • Find the currently active cell If you’ve been scrolling around your spreadsheet and you lose your place, you can jump back to the currently active cell by pressing the [Ctrl] + [Backspace] keys.
    Posted Mar 24, 2011, 8:11 AM by Ayush Jain
  • How to hide formulas in MS Excel worksheets This trick will let you hide the formulas & keeping the worksheet usable, by performing the following steps:Select all cells (either press Ctrl+A or click on the small upper ...
    Posted Feb 25, 2011, 11:24 PM by Ayush Jain
  • Hide the Ribbon in Office 2007 / 2010 Press Control + F1 and ribbon disappears and press again to reappear ribbon. You can also have it disappear so it will come back with a single click on any tab ...
    Posted Jan 30, 2011, 7:28 AM by Ayush Jain
  • Inconsistent date entries You need to exercise caution when entering dates by using two digits for the year. When you do so, Excel has some rules that kick in to determine which century ...
    Posted Jan 30, 2011, 7:26 AM by Ayush Jain
Showing posts 1 - 5 of 8. View more »

Visit EXCELDAILYTIP blog to learn 70 + Excel Tips & Tricks.

Submit Excel Tips here

Subpages (1): Excel Tips