There are many times data integral to the performance of your spreadsheet does not need to be visible in your presentation. After this video you will be able to apply the hide and unhide options in your Excel projects.
- [Instructor] On this worksheet called hide/reveal…in our chapter four file called RowColumnAdjustments,…we've got some data in columns D and E…that needs to be there, but, really, do we need to see it?…We want to get it out of the way of columns…but without destroying the data.…We can hide columns, we can also hide rows,…we can hide worksheets.…If we don't want to see columns D and E, let's hide them.…Click and drag across the columns, right-click, Hide.…Now as I click elsewhere,…notice the separator between columns C and F,…that's where the hidden columns are, of course.…
It's a double-line,…so it's a visual there that reminds us…that there's something hidden.…And by the way, over the years, at different times,…I'm surprised at myself for not picking up on the idea…that in certain worksheets, some columns were hidden,…I just overlooked them.…So from time to time, give a glance to those letters…and just make sure there's nothing hidden…that you don't know about.…Of course, we want to get the data back at different times.…
- Controlling fonts, borders, colors, and alignment
- Adjusting numeric formats quickly
- Accentuating dynamic data with conditional formatting
- Adjusting rows and columns