The Quick Access toolbar is very customizable as Excel makes it really easy to add any Ribbon command to it. But you’re not restricted to add buttons for just the commands on the Ribbon.
Archive of posts filed under the How to category.
How to Save New Excel File with Summary Information
What is the Summary Information of the MS Office files for? How you can make use of the file properties to save time from search the document? How to set entering the data by default in MS Office? Learn all the tricks here!
13 Tips to Speed Up MS Excel Data Entry
Learn 13 time saving tips to speed up data entry in Microsoft excel. Many keyboard shortcuts to make your job more efficient
What is Excel Workspace
Learn what is Excel Workspace and how it can help you to save your time from reopen the same excel files, excel windows settings again and again.
Enable full toolbars and menus in Excel
Stop wasting time in clicking Excel’s toolbar options button, access to options that are currently hidden by displaying all toolbars and menus.
Moving around excel spreadsheet with Ctrl, Shift and Arrow Keys
Learn to be more efficient working with Excel. Navigating and selecting cells can be so much simpler if you know the shortcuts. These tips save you from scrolling up and down, left and right. You will love it!
Show only columns and rows you interested
Tips to prevent certain information from being seen in excel. How to hide or unhide columns or rows so that it simplify the spreadsheet view area when you are working on a large worksheet. This is alternative trick if you dont have a big screen or monitor.
Split windows and freeze spreadsheet panes
Learn how to get more viewing space for Ms Excel. By easy the freeze panes and split windows help you to scrolls the rows and columns to save your time when dealing with spreadsheets.
The use of Excel template: Saving Custom Display Settings
Save your time by create an excel template to store the display settings that you find yourself manually changing over and over again such as insert additional worksheet, remove gridlines, and select new standard column width
Modify worksheet gridlines for better appearance
Avoid confusing gridlines for excel online forms and presentations with embedded charts and assign new color to gridlines for easier to read excel worksheets