How to Remove Extra Unused Cells in Microsoft Excel 2. Merge cells and adjust row height or column width to make cells bigger in Excel. Ablestock. comAble. Stock. comGetty Images. Worksheets in Microsoft Excel can contain over a million rows and over 1. With a workspace that large, if youre not careful, you can both easily and unintentionally enter data into the wrong cell which, depending on what youre working on, can interfere with important calculations. Fortunately, just as you can remove empty cells in a printout, you can also hide them on your PC. Tera Term Serial Macro Examples here. Press Ctrl End to move to the end of your worksheet and then select the cell located directly below the current cell. Press Ctrl Shift Down to move to the bottom row and then select Format from the Cells group on the Home tab. Point to Hide Unhide and then choose Hide Rows from the menu to remove all of the selected rows from your worksheet. Return to the last cell in your worksheet and then select the cell located directly to the right. Interested in learning more about Excel VBA MrExcel will teach you how to use Microsoft Excel VBA. Check out our site for more information about Excel VBA tutorials. Press Ctrl Shift Right to highlight the remaining columns and then click Format. Point to Hide Unhide and then choose Hide Columns from the menu to remove the selected columns. Tip. To hide unused cells on a printed page, select the cells you want to print and then go to the Page Layout tab. Select Print Area from the Page Setup group and then click Set Print Area. About the Author. Ruri Ranbe has been working as a writer since 2. She received an A. A. in English literature from Valencia College and is completing a B. S. in computer science at the University of Central Florida. Ranbe also has more than six years of professional information technology experience, specializing in computer architecture, operating systems, networking, server administration, virtualization and Web design. Photo Credits. Ablestock. How to display or hide sheet tabs and Sheet Tab Bar in Excel By default, Microsoft Excel shows sheet tabs at the bottom of the worksheet, which is functioning for. How to Hide Cells. Excel does not have the ability to hide a cell in the traditional sense that they simply disappear until you unhide them, like in the example above. Keystrokes useful in Microsoft Excel spreadsheets. Command Keystroke Absoluterelativemixed reference F4 AutoSum Alt Bold CtrlB. Hi, Im new to excel VBA. Need to do the following in a worksheet Inlet chevron If cell A3 Combination, then hide rows 7 to 64 and unhide rows 65 t. How to Hide Rows in Excel. Hiding rows you dont need can make your Excel spreadsheet much easier to read, especially if its large. Hidden rows dont. New features that are not supported in earlier versions of Excel. Not all new features are supported in earlier versions of Excel. When you work in Compatibility Mode. Microsoft Excel Hide Unhide Cells In Excel' title='Microsoft Excel Hide Unhide Cells In Excel' />Able. Stock. comGetty Images. How to Unhide Rows in Excel. The power of Microsofts Excel spreadsheet program lies in your ability to customize your spreadsheet with formulas, formatting and graphs. Learn how to hide and unhide columns and rows in Excel 2010. Sage South Africa Pty Ltd 2016. All Rights Reserved.