Note: A table name is the name for an Excel table, which is a collection of data. We suggest removing conditional formatting from your spreadsheet as soon as you are done with it. Select characters in a cell or cell range that youd like to format. For a complete list of Windows and Mac shortcuts, see our side-by-side list. The shortcut to toggle absolute and relative references is F4 in Windows, while on a Mac, its Command T. For example, the shortcut for Edit Cell in Windows is F2, and on a Mac, its Control + U. But the truth is that it can quickly make your Excel file heavy. Finally, some Excel shortcuts are just plain different on a Mac. Here are seven tips to reduce your Excel file size right now: Tip #1: Remove conditional formattingĬonditional formatting comes in handy when you need to highlight specific data. As seen above, you can start by focusing on the heaviest worksheets. For example if I select cell F2 and then type the name Vd into the 'name box' (left end of the formula bar) the cell at F2 is now named 'Vd'. Pick any large Excel file you want to lighten. I changed the name of a few cells in an Excel worksheet and now I want to restore the default name but cannot find a way to do that. Here is the detailed guide for finding a sheet’s name. One way to know for certain you have the right sheet is to get the exact name. If you have a lot of hidden sheets, it can become tricky to find the right one. Usually, it corresponds to the n+1 sheet in your Excel file in the above example, we could start by trimming the twenty-seventh sheet.īe careful! The n+1 rule takes into account hidden sheets.

For instance, “sheet26.xml” accounts for almost one-third of the global volume. Spotting the heaviest sheets can help you choose which to start with.