Worksheet Fundamentals

Fundamentals of Worksheet

• A workbook is a collection of one or more spreadsheets, also called worksheets, in a single file.
• Each spreadsheet can have many sheets and each sheet can have many individual cells.
• Each sheet can have a maximum of 65,536 rows and a maximum of 1024 columns, for a total of over 67 million cells.
• A workbook can contain one or more different worksheets that can be accessed through the tabs at the bottom of the worksheet.
• A spreadsheet and worksheet mean the same thing.
• A particular cell is identified by its column letter and row number.
• These cells hold the individual elements—text, numbers, formulas, and so on—that make up the data to display and manipulate.

Adding Worksheet

• To insert new worksheets:
• Click on the Insert menu and select Sheet.
• Right-click on its tab and select Insert Sheet.

Text Alignment

• Left Aligned: Aligns the beginning of each line of text along the left margin of the cell.
• Right Aligned: Aligns the beginning of each line of text along the right margin of the cell.
• Centered: Places text in the center of each line.
• Justified: Combines left and right aligned text, filling the entire space from left to right.

Number Format

• Number formats are template strings consisting of format codes defining how numbers or text appear.

Inserting Elements

• Insert Image: To add any image from a file, select the Picture option from the Insert menu.
• Insert Shapes: To add any type of shape, select the VIEW menu -> TOOLBAR -> DRAWING option.
• Insert Textbox:
• Click on the VIEW menu -> TOOLBAR -> Form Control.
• Select the Text Box option.
• Insert Symbols:
• Special characters are not found on a standard English keyboard (e.g., © ¾ æ ç ñ ö ø ¢).
• To insert symbols, press Alt + T and then press Alt + S, or use the Spell-check window.

Spell Check

• Features of Spell Check utility:
• Enable Spell check: Click on the Auto Spellcheck icon from the standard toolbar.
• Suggestions: Right-click on the misspelled word to get suggested words.
• Ignore All: The misspelled word will be ignored by the spell checker.
• Replace: Select the misspelled word and click on the Spelling icon or right-click and select "Spellcheck..."

Text to Columns

• Used to split columns into smaller parts.
• Select the column and click on Data > Text to Columns.
• Select the Separated by radio button and choose a separator (e.g., Tab, Space, Comma, Merge delimiters, or Semicolon).
• The column will split at the specified separator.
• Alternatively, use the Fixed width option and adjust the ruler on the preview window to set a width for the column to split at.