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.3. Changing the Width and Height of Cells

The next topic that I want to get into is a common question that I get since I make Excel trainings. This deals with changing the width of a column and the height of a row. this shows up in various questions that I get for many different reasons.

One I just want to get in there make it look a little more presentable.

The other reason I get this question quite a bit of is because data starts to get cut off it. The column is too narrow, or the row is just too low right. It is just it is now high enough the height is not presenting all the data.

For example, as below:

Changing the Width and Height of Cells 1

Why that happens is because it is a numeric value. Remember that dates are numeric to Excel and it is just too narrow for the month of March.

So all I need to do here is move up to E column, I move my cursor between E and F, I move my cursor, I get that kind of two headed arrow, I left click and drag.

Changing the Width and Height of Cells 2

This will allow me to adjust the width of that column, you will see if I narrow it too much I go back to those pound symbols by narrow way too much then I am starting to get pound symbols instead of all those numeric values.

Changing the Width and Height of Cells 3

I just drag that out just to give it a little bit more space and accommodate for the size of those values.

Now if it is not numeric you do not get the ### symbols if it is too narrow, but it just gets cut off.

Changing the Width and Height of Cells 4

You do the same thing with Row. If I want to increase the height or decrease the height, I can go in between two rows five and six, I will grab that line and just drag it to increase or decrease the height of that row.

Changing the Width and Height of Cells 5

That can be super useful not just for revealing more content, but if you want to increase the height and color the background to do some formatting commands.

It can also happen if you end up wrapping tags or have a big paragraph of text and you need to increase the width and height of that cell.

Now, I am going to give you one more tip, actually two more tips.

I love tips, I love shortcuts. Something else you can do if you want to automatically adjust a column. I want to adjust the column with, and I want it to find the largest value in that column and adjusted to that.

I just wanted to auto fit if I move my cursor in between the two columns again get that double headed arrow once again. I will just double click, and it will auto fit to the largest value in that column.

Changing the Width and Height of Cells 6

Something else you can do. Love this one, and it is a question I get asked all the time “How can I just multiple columns?”.

If I want to adjust all three months and the total and the percent (C column to G column), let us just draw more and then exclude the bills that, I am going to highlight C column to G, I am going to go to column between E and F or D and E and I am going to left click and drag.

Changing the Width and Height of Cells 7

I am just adjusting the D column but as soon as I let go it will adjust all of them. if I double click in between one of them it will auto fit every column, love it.  you want it to be uniform consistent highlight all the columns readjust and adjust each column, and the same will be true with rows you highlight multiple rows in there. You drag it one along and it will adjust all of them for you.

Another way to do this. Right-click on header of column then select Column width.. command.

Changing the Width and Height of Cells 8

Then set exact column width you want in the Column width box.

Changing the Width and Height of Cells 9

You do same with Row Height, Right click on header of row, select Row height.. command.Changing the Width and Height of Cells 10

Then set row height in the row height box.

Changing the Width and Height of Cells 11

Again, modifying your existing worksheet, making sure that your data is presentable that you can read.

You are not getting those ### symbols where your numbers, you are not cutting off values.

Try it out get some practice with it, a single column, multiple columns double quick for an auto fit, adjust your columns.