• Hiding Unwanted Text - Excel Tips

  • Excel Tips from Xlteq - Hiding unwanted text

    If you want to hide just a small section of the worksheet and not the whole row or column you can easily hide the text by changing the text colour to be the same as the background colour. Simply highlight the text and click the font button on the toolbar.

    hiding unwanted text 1

    Alternatively, if you do not want to change the colours of your spreadsheet, you can change the number format to three semicolons ‘;;;’.

    Highlight the text, right-click and choose ‘Format Cells’ from the menu. Select the ‘Custom’ option and type three semicolons ‘;;;’ into the text box and confirm by clicking ‘OK’.

    hiding unwanted text 2

    In each of these cases, the text isn’t visible, but you can still refer to values of cells in formulas.

     

    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