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.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.