You can make your Excel work faster and easier by taking advantage of smart tags. A smart tag is a special icon that appears when you perform certain Excel tasks.
Archive of posts filed under the How to category.
Excel Column Naming Convention
How to assign 16384 columns in excel with the 26 letters from A to Z.
Add Command Button To Ribbon
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.
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.