• Excel Tips and Support - Hiding rows or columns

  • Excel support

    Excel Support - Hiding rows or columns

     

    Sometimes when you have a large spreadsheet, you may want to hide some of the information from view.

    Simply highlight the row or column by clicking the appropriate header, right-click and select ‘Hide’ from the menu.

    You can even select multiple rows or columns by selecting the first row or column, then holding down the SHIFT key select the last row or column. If you want to be more selective, hold down the CTRL key instead and select each row or column before hiding them (Please note that you cannot hide both rows and columns at the same time).

    Hiding rows and columns 1

    If you want to unhide a row or column, simply select each row or column on each side of the hidden item, right-click and select ‘Unhide’ from the menu.

    Hiding rows and columns 2

    Read about some of our Excel Development Projects

    A leading Auctioneer came to xlteq to help streamline and automate their global headcount reporting in Excel. This included real-time clarification of total headcount coupled with detailed location status functionality.

    Find our more 

    A Danish financial services company asked our Excel Consultants for support with preparing their client investment portfolios. This task now takes less than a minute per customer and is delivered in a format selected by the client then presented as a visually effective Investment Portfolio Dashboard.

    Find out more