OBINTUSACADEMY
HOME CONTACT SERVICES PRIVACY
COMPUTER BASICS MS-PACKAGES
Excel - Format Worksheet, Cells, Rows and Columns

MICROSOFT EXCEL

MODULE ONE

Prerequisite Introduction to Microsoft Excel Getting Started MS Excel Environment Title Bar Quick Access Toolbar Search Account Name Buttons Menu Tab Ribbons Dialog Box Launcher Name Box Insert Function Formula Bar Worksheet Area Worksheet Navigation Creating New Sheet Status Bar Worksheet View Format Zoom Slider MS Excel File Tab Entering Data Saving Your Workbook Opening Saved Workbook Copy, Delete and Hiding Sheet Closing Entire Workbook

MODULE TWO

Cells, Rows and Columns Resizing Rows and Columns Inserting Data Select, Delete and Move Data Copy, Paste and Cut Find and Replace Checking Spellings Inserting TextBox Inserting Symbols Inserting Special Characters Zooming Undoing and Redoing Changes

MODULE THREE

Mini Toolbar Setting Fonts Text Decoration Setting Text Case Text Alignments Text Orientation Increase and Decrease Indentation Wraping Text Merging Cells Cells Borders Cells Shades Copy Formatting Insert and Delete Worksheet Format Worksheet, Cells, Rows and Columns

MODULE FOUR

Insert Tables Insert Pictures Insert Shapes and Smart Art Insert Screenshots Insert Icons Insert 3D-Models Using Add-ins Insert Charts 3D Maps Creating Sparklines Insert WordArt

MODULE FIVE

Addition Subtraction Multiplication Division Using Formulas Using Functions Quick Functions

MODULE SIX

Fill Handling Sorting Filtering References (Relative and Absolute) Conditional Formatting Applying Styles

MODULE SEVEN

Page Themes Page Colors Page Fonts Page Effects Page Header and Footer Page Numbering Page Margins Page Orientation and Size Print Area Page Breaks Setting Background Print Titles Preview and Print Share Workbook Freezing Panes Range Data Validation Excel Templates MS Excel Shortcuts Conclusion

HOW TO

Excel How-To Send Email Separate Text Date and Time Format Macro Thesaurus Insert Comments Password Workbook Count Characters Count Words Add and Remove Hyperlinks Insert PDF in Excel Editing and Formatting Restrictions How to Compare Columns How to Compare Worksheets Add Signature in Worksheet Calculate Age Calculate Mean Calculate Median Calculate Standard Deviation Find the Mode Add and Remove Commas How to Remove Filter Convert Excel to CSV Excel to PDF Excel to Ms-Word Document Excel to Picture Formats Duplicate Rows and Columns Hide and Unhide Rows and Columns Rows and Columns Conversion How to Remove Gridlines Create Graphs Insert Check Box Add and Remove Watermark Logical Operators Logical Functions Text Functions Square Symbol Pi Symbol Selecting Different Columns Creating QR Code Creating Bar Code Insert Bullet Points Generate Random Numbers Combine Two Columns Wrap Text Create Dropdown List

Format Worksheet, Cells, Rows and Columns

PREVIOUS NEXT

In this tutorial, I am going to be showing the how you can format worksheet, cells, rows and columns using different options available in the formatting options in excel. This is very easy to follow through, just follow it step by step and you will understand everything.

  • SETTING ROW HEIGHT
  • Step 1 - Open the excel worksheet and click the row that you want to set its row height. Inside the Home tab, go to the Cells group and click on the Format option.
    This will display a dropdown list of options. Under the section Cell Size click on the Row Height option.
    • setting-row-height
  • Step 2 - A small dialog box will be displayed. Here you set the height of the rows in the worksheet by typing the value inside the Row Height input field. Then click the Ok button.
    • setting-row-height
  • Step 3 - Row Height set successfully.
    • setting-row-height
  • AUTOFIT ROW HEIGHT
  • Autofit row height is when excel helps you to automatically resize the row height to accommodate the text length without manually resizing it using your mouse.
  • Step 1 - Open the excel worksheet, select the cells or row that you want to set to autofit row height.
    Now click the Home tab, go to the Cells group and click on the Format option.
    This will display a dropdown list of options. Under the section Cell Size click on the AutoFit Row Height option.
    • autofit-row-height
  • Step 2 - The height of the selected cells or rows in the worksheet will be set to autofit row height.
    • autofit-row-height
  • SETTING COLUMN WIDTH
  • Step 1 - Open the excel worksheet and click or select the column(s) that you want to set its column width. Inside the Home tab, go to the Cells group and click on the Format option.
    This will display a dropdown list of options. Under the section Cell Size click on the Width option.
    • setting-column-width
  • Step 2 - A small dialog box will be displayed. Here you set the width of the columns in the worksheet by typing the value inside the Column Width input field. Then click the Ok button.
    • setting-column-width
  • Step 3 - Column width set successfully.
    • setting-column-width
  • AUTOFIT COLUMN WIDTH
  • Autofit column width is when excel helps you to automatically resize the column width to accommodate the text length without manually resizing it using your mouse.
  • Step 1 - Open the excel worksheet, select the cells or columns that you want to set to autofit column width.
    Now click the Home tab, go to the Cells group and click on the Format option.
    This will display a dropdown list of options. Under the section Cell Size click on the AutoFit Width option.
    • autofit-column-width
  • Step 2 - The width of the selected cells or columns in the worksheet will be set to autofit width.
    • autofit-column-width
  • SETTING DEFAULT WIDTH
  • Default width is used when you want all the width, in your excel worksheet to be the same.
  • Step 1 - Open the excel worksheet that you want to change the default width. Inside the Home tab, go to the Cells group and click on the Format option.
    This will display a dropdown list of options. Under the section Cell Size click on the Default Width option.
    • setting-default-width
  • Step 2 - A small dialog box will be displayed. Here you set the default width in the worksheet by typing the value inside the Standard Column Width input field. Then click the Ok button.
    • setting-default-width
  • Step 3 - Default width set successfully.
    • setting-default-width
  • HIDING ROWS AND COLUMNS
  • Step 1 - Open the excel worksheet, select the rows or columns that you want to hide
    Now click the Home tab, go to the Cells group and click on the Format option.
    This will display a dropdown list of options. Under the section Visibility move you mouse over the option Hide & Unhide which will display further option. Now you can click on Hide Rows or Hide Columns to hide either rows or columns.
    • hide-rows-and-columns
  • Step 2 - The selected rows or columns will be hidden successfully.
    • hide-rows-and-columns
  • UNHIDING ROWS AND COLUMNS
  • Step 1 - Open the excel worksheet, type in the name of the column or row address you want to unhide inside the name box and press enter on your keyboard to go to that location.
    • unhide-rows-and-columns
  • Step 2Click the Home tab, go to the Cells group and click on the Format option.
    This will display a dropdown list of options. Under the section Visibility move you mouse over the option Hide & Unhide which will display further option. Now you can click on Unhide Rows or Unhide Columns to hide either rows or columns.
    • unhide-rows-and-columns
  • Step 3 - The hidden rows or columns will now be visible.
    • unhide-rows-and-columns
  • HIDING WORKSHEET
  • Step 1 - Open the excel worksheet, that you want to hide. Click the Home tab, go to the Cells group and click on the Format option.
    This will display a dropdown list of options. Under the section Visibility move you mouse over the option Hide & Unhide which will display further option. Now you can click on Hide Sheet to hide that worksheet.
    • hide-worksheet
  • Step 2 - The worksheet will be hidden successfully.
  • UNHIDING WORKSHEET
  • Step 1 - Open the excel workbook that contains the hidden worksheet, that you want to unhide. Click the Home tab, go to the Cells group and click on the Format option.
    This will display a dropdown list of options. Under the section Visibility move you mouse over the option Hide & Unhide which will display further option. Now you can click on Unhide Sheet
    • unhide-worksheet
  • Step 2 - A dialog will display. In this dialog box, just click on the worksheet you want to unhide and click the Ok button.
    • unhide-worksheet
  • Step 3 - The worksheet will now be visible.
    • unhide-worksheet
  • RENAMING WORKSHEET
  • Step 1 - Open the excel worksheet, that you want to rename. Click the Home tab, go to the Cells group and click on the Format option.
    This will display a dropdown list of options. Under the section Organize Sheets click on the Rename Sheet option.
    • rename-worksheet
  • Step 2 - The name of that sheet at the bottom before the status bar will now be editable. Now type in the new name you want.
    • rename-worksheet
tips
TIP:

An alternative way to rename a worksheet is by double clicking on the name of the sheet and edit it.

  • CHANGING WORKSHEET TAB COLOR
  • Step 1 - Open the excel worksheet, that you want to change the tab color. Click the Home tab, go to the Cells group and click on the Format option.
    This will display a dropdown list of options. Under the section Organize Sheets move your mouse pointer over the option Tab Color. This will display the color options. Click on any of your preferred color and it will be applied to the tab.
    • worksheet-tab-color
  • Step 2 - DONE!
    • worksheet-tab-color
  • PROTECTING WORKSHEET
  • Step 1 - Open the excel worksheet, that you want to protect. Click the Home tab, go to the Cells group and click on the Format option.
    This will display a dropdown list of options. Under the section Protection click on Protect Sheet option.
    • protect-worksheet
  • Step 2 - A dialog will be displayed. In the dialog box, type in the password that you want to use to protect the worksheet. (This password will be required to unprotect the worksheet when you want make any changes in it again)
    Make sure you mark the checkbox beside Protect worksheet and contents of locked cells. You can also enable different options for users by marking any of the checkboxes option you want which is good for you.
    After you are done, click the OK button.
    • protect-worksheet
  • Step 3 - Another small dialog box will be displayed for you to confirm your worksheet password. Just as stated in the description in the dialog box, if you forget the password you won't be able to recover it back so be very careful when doing this.
    • protect-worksheet
  • Step 4 - After clicking OK button, your worksheet is now protected.
  • Step 5 - Anytime you or someone else wants to edit the worksheet, excel will display a dialog box telling you that for you to edit the worksheet you will have unprotect the worksheet.
    • protect-worksheet
  • UNPROTECTING WORKSHEET
  • Step 1 - Open the excel protected worksheet, that you want to unprotect. Click the Home tab, go to the Cells group and click on the Format option.
    This will display a dropdown list of options. Under the section Protection click on Unprotect Sheet option.
    • protect-worksheet
  • Step 2 - A small dialog will be displayed. Inside the dialog box, type in the password for that worksheet and click the OK button.
    • protect-worksheet
  • Step 3 - Worksheet is now unprotected and you can now edit the worksheet.
  • LOCKING CELLS
  • Locking cell has to do with preventing user from making changes to a particular cell.
  • Step 1 - Open the excel worksheet, select the cell(s) that you want to lock. Click the Home tab, go to the Cells group and click on the Format option.
    This will display a dropdown list of options. Under the section Protection click on Lock Cell option.
    • lock-cells
  • Step 2 - The selected cell(s) is now locked successfully.
note
NOTE:

For the lock cell feature to work the worksheet has to be protected.

PREVIOUS NEXT
ADVERTISEMENTS

LEARNING IS A CONTINOUS PROCESS - PRACTICE MAKES PERFECT