Microsoft Excel

2.1 Opening Microsoft Excel 2.2 Microsoft Excel Startup Screen 2.4 Introduction to the Excel Interface 2.5 Customizing the Excel Quick Access Toolbar 2.6 More on the Excel Interface 2.7 Understanding the Structure of an Excel Workbook 2.8 Saving an Excel Document 2.9 Opening an Existing Excel Document 2.10 Common Excel Shortcut Keys 3.1 Entering Text to Create Spreadsheet Titles 3.2 Working with Numeric Data in Excel 3.3 Entering Date Values in Excel 3.4 Working with Cell References 3.5 Creating Basic Formulas in Excel 3.6 Relative Versus Absolute Cell References in Formulas 3.7 Understanding the Order of Operation 4.1 The structure of an Excel Function 4.2 Working with the SUM() Function – Excel 4.3 Working with the MIN() and MAX() Functions 4.4 Working with the AVERAGE() Function 4.5 Working with the COUNT() Function 4.6 Adjacent Cells Error in Excel Calculations 4.7 Using the AutoSum Command 4.8 Excel’s AutoSum Shortcut Key 4.9 Using the AutoFill Command to Copy Formulas 5.1 Moving and Copying Data in an Excel Worksheet 5.2. Inserting and Deleting Rows and Columns 5.3. Changing the Width and Height of Cells 5.4 Hiding and Unhiding Excel Rows and Columns 5.5 Renaming an Excel Worksheet 5.6. Deleting an Excel Worksheet 5.7 Moving and Copying an Excel Worksheet 6.1 Working with Font Formatting Commands 6.2. Changing the Background Color of a Cell 6.3. Adding Borders to Cells 6.4. Formatting Data as Currency Values 6.5. Formatting Percentages 6.6. Using Excel’s Format Painter 6.7. Creating Styles to Format Data 6.8. Merging and Centering Cells 6.9. Using Conditional Formatting 7.1 Inserting Images and Shapes into an Excel Worksheet 7.2 Inserting Shapes In Excel 7.3 Formatting Excel Shapes 7.4. Working with Excel SmartArt 8.1. Creating an Excel Column Chart 8.2. Working with the Excel Chart Ribbon 8.3. Adding and Modifying Data on an Excel Chart 8.4. Formatting an Excel Chart 8.5. Moving a Chart to another Worksheet 8.6. Working with Excel Pie Charts 9.1. Viewing your Document in Print Preview 9.2. Changing the Margins, Scaling and Orientation 9.3 Adding Header and Footer Content 9.4 Printing a Specific Range of Cells 10.1. Intro to Excel Templates 10.3. Opening an Existing Template 10.4. Creating a Custom Template 13.1 Understanding Excel List Structure 13.2 Sorting a List Using Single Level Sort 13.3 Sorting a List Using Multi-Level Sorts 13.4 Using Custom Sorts in an Excel List 13.5 Filter an Excel List Using the AutoFilter Tool 13.6 Creating Subtotals in a List 13.7 Format a List as a Table 13.8 Using Conditional Formatting to Find Duplicates 13.9 Removing Duplicates in Excel 14.1 Excel DSUM Function Single Criteria 14.2 Excel DSUM Function with OR Criteria 14.3 Excel DSUM Function with AND Criteria 14.4 Excel Function: DAVERAGE() 14.5 Excel Function: DCOUNT() 14.6 Excel Function: SUBTOTAL() 15.1 Creating an Excel Data Validation List 15.2 Excel Decimal Data Validation 15.3 Adding a Custom Excel Data Validation Error 15.4 Dynamic Formulas by Using Excel Data Validation Techniques 16.1 Importing Data from Text Files into Excel 16.2 Excel 2019

5.4 Hiding and Unhiding Excel Rows and Columns

Just a look at increasing the height or the width or decreasing the width and height of columns and rows. What about hiding a column or hiding multiple columns or rows. I do not want people to see this data. I do not want everybody that goes into the worksheet to see that data or we really do not need that data at this point.

Do not delete it because you want to keep that around. But I will hide a column or multiple columns or rows.

If I go into the worksheet let us say I do not care about January anymore. I want to keep the data around historically we want that data, but I want to hide it Or perhaps there is more sensitive type information than I do not need users to get access to.

This is also useful when you go to print your content whatever is hidden does not print out.

I can do this a couple of different ways.

I am going to select column C. That is the column that I want to hide.

I am going to right click on header of the C column, then select Hide command.

Hiding and Unhiding Excel Rows and Columns 1

The data still there, Column C is still there. We just essentially took the column with it smashed it.

I can just go right up in between column B and D and C, I get that double headed arrow but it is got kind of a space in between it. If I left click and drag, I can pull Column C back out and there is the data again.

Hiding and Unhiding Excel Rows and Columns 2

That keeps them from looking at it, but they can still go on hide it. In the book, we will go into the review tab. And then there you have an option for protect sheet. We will talk some more about that.

Or other way, after hide column, If I want to unhide column. I will select multiple columns, right click on any highlight column then select Unhide column

Hiding and Unhiding Excel Rows and Columns 3

There is so much more you can do here. If you really want to lock that down, you can protect the sheet.

I am going to give you one more little tip, on The Review tab top of your screen right, there is also some show checkmarks out there. One of them is headings. This is something small but if I uncheck that option for headings, I no longer see the ABC column and the one two three rows.

Hiding and Unhiding Excel Rows and Columns 4

That could also potentially be used here if you are really trying to distract the users and you do not want them to gain access to it.

Again, you get the more advanced users inside of Excel, that can go right back to view turn headings back on.

Really worksheet protection is going to take it much further for us and again just watch for that later in the book.

Try this one out again, you can right click hide. You can just smash them down do the same thing with a row. if you want to show it again You can just drag that back out.

Right click hide, right click Unhide click and drag to increase or decrease the column with or row height and you can hide content.