This tutorial demonstrates how to view a list of worksheet tabs in Excel and Google Sheets. View List of Worksheets At the bottom of an Excel file, you can see tabs representing each sheet. When there’s a lot of sheets in a document, not all of the tabs can be displayed at once.… Continue Reading
This tutorial demonstrates how to use automatic formatting in Excel. Add AutoFormat to Quick Access Toolbar To use AutoFormat, first add it to the quick access toolbar. Click on the Customize Quick Access Toolbar drop-down arrow and from the list, choose More Commands… This opens the Excel Options window. Click Popular Commands under Choose commands… Continue Reading
This tutorial demonstrates how to mask data input in Excel and Google Sheets. What does it mean to “mask” data in Excel? Do you want to hide sensitive information? Or, do you want to apply a number format that can simplify data entry? Click here to jump to the Google Sheets walkthrough. Mask… Continue Reading
This tutorial demonstrates how to change cell size in pixels or inches in Excel and Google Sheets. Change Ruler Units From Pixels to Inches Sometimes you’ll need to change cells’ sizes in inches – rather than pixels – to accurately match your data or template. One way to do that is to use… Continue Reading
This tutorial demonstrates how to hide cells in Excel and Google Sheets. Hide Unused Cells – Excel Ribbon Hide Unused Columns Excel doesn’t give you the option to hide individual cells, but you can hide unused rows and columns in order to display only the working area. To hide unused columns using the… Continue Reading
This tutorial demonstrates how to hide page breaks in Excel. Hide Page Breaks In Excel, you can choose where to go to the next page when printing by setting page breaks. To hide them while you are in normal view, follow these steps: In the Ribbon, go to File > Options. In the Excel Options… Continue Reading
This tutorial demonstrates how to enable or disable smart tags in Excel and Google Sheets. What Are Smart Tags? Smart tags are small icons that appear under cells after some action with data in the spreadsheet. The most common smart tag appears when you copy and paste data, offering different paste options. After… Continue Reading
This tutorial demonstrates how to clear the cache in Excel and Google Sheets. Clear Cache in Excel If you have a problem with editing a document or Excel is taking too long to load, you should try clearing the cache. In the Ribbon, select File > Options. Scroll down to the bottom… Continue Reading
This tutorial demonstrates why AutoSave might be grayed out or not working in Excel. AutoSave is a new feature in Office365 that allows you to save your work in real time, meaning it automatically saves every few seconds as you work. To enable AutoSave, files must be saved to OneDrive or SharePoint. If… Continue Reading
This tutorial demonstrates how to define print titles – rows and/or columns printed on every page – in Excel and Google Sheets. In Excel, you can use Page Setup to print the top row or the leftmost column on every page. We’ll explain in detail how to set the top row to repeat,… Continue Reading