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.
Archive of posts filed under the How to category.
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
Customize Excel Column Width and Row Height
If you’re working on a spreadsheet that requires a different standard column width, you can easily set a default width for every column in the worksheet
Customize number of worksheets in a workbook
if you find yourself having to manually add new sheets to many of the new workbooks you start, you should probably modify the default number of sheets that Excel adds to all new workbooks
Switching In and Out of Full Screen View in Excel
Learn how to switch in and out of Full Screen view, Controlling the Excel display screen includes not only hiding unwanted toolbars that surround the worksheet but also modifying the sheet’s look and feel.