Excel Functions


Excel Basics

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

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.