Launching excel:
windows task bar >> start >> Search Excel >> Open
When you open Excel, you'll see a start screen displaying a blank workbook, various templates to choose from, as well as options for account settings and recently opened workbooks. Click Blank Workbook to begin.
Basic Control and Parts of Excel Window
2. **File Tab**: Replaces the Office button, allowing file operations like opening, saving, and printing.
3. **Title Bar**: Displays the name of the current document at the top of the window.
4. **Control Buttons**: Located at the top-right corner, these buttons help you minimize, maximize, or close the window.
5. **Menu Bar**: Contains tabs like File, Insert, and Data for accessing different commands.
6. **Ribbon/Toolbar**: Shows commands organized by tabs (e.g., Home, Insert) and groups within them (e.g., fonts, alignment).
7. **Dialog Box Launcher**: A small arrow in the lower-right of a command group that provides more options.
8. **Name Box**: Shows the location of the active cell or range.
9. **Formula Bar**: Allows you to view and edit the content or formula of the active cell.
10. **Scrollbars**: Used to move around the document vertically and horizontally.
11. **Spreadsheet Area**: Where you enter data, including rows, columns, and cells.
12. **Sheet Tab**: Located at the bottom, it shows the current sheet and lets you switch between sheets.
13. **Columns Bar**: Displays column labels (A, B, C, etc.) and is located below the formula bar.
14. **Rows Bar**: Displays row numbers (1, 2, 3, etc.) on the left side of the sheet.
15. **Cells**: Individual boxes in the spreadsheet, identified by their column letter and row number (e.g., A1).
16. **Status Bar**: At the bottom, shows summary info and lets you customize what’s displayed.
17. **View Buttons**: Three buttons for different views: Normal, Page Layout, and Page Break.
18. **Zoom Control**: Located at the bottom-right, lets you zoom in and out of the spreadsheet
Hide Excel Ribbon
The middle blank area is called a workbook, which contains multiple worksheets. A worksheet is where you enter and organize your data.
- Total columns: XFD (16,384)
- Total rows: 1,048,576
- To quickly navigate:
- Ctrl + → / ↓ → Move to the last column or row
- Ctrl + Home → Return to cell A1
Quick Access Toolbar:
- Use the Save button or press Ctrl + S to save your work quickly.
File Tab Options:
- Save / Save As:
- Choose Save As when creating a new file for the first time.
- Use Save to update an existing workbook.
- Open:
- Access previously saved Excel files or browse to open a new one.
🔹 Basic File Operations
- Ctrl + S : Save worksheet
- Ctrl + O : Open worksheet
- Ctrl + W : Close worksheet
- Alt + F → Save / Save As : Save new or existing file
- Ctrl + P : Print worksheet
🔹 Navigation & Tabs
- Alt + H : Go to Home tab
- Alt + N : Go to Insert tab
- Alt + P : Go to Page Layout tab
- Alt + M : Go to Formula tab
- Alt + A : Go to Data tab
- Alt + W : Go to View tab
🔹 Editing & Formatting
- Ctrl + C : Copy
- Ctrl + X : Cut
- Ctrl + V : Paste
- Ctrl + Z : Undo
- Delete : Clear cell contents
- Ctrl + B : Bold text
- Alt + H, H : Choose fill color
- Alt + H, A, C : Center align contents
- Alt + H, B : Add borders
- Alt + H, D, C : Delete column
🔹 Row & Column Management
- Ctrl + 9 : Hide selected rows
- Ctrl + 0 : Hide selected columns
🔹 Cell Navigation
- Shift + Tab : Move to previous cell
- Up Arrow : Move one cell up
- Down Arrow : Move one cell down
- Left Arrow : Move one cell left
- Right Arrow : Move one cell right
- Ctrl + Arrow key : Jump to edge of data region
- End + Arrow key : Move to next nonblank cell
- Ctrl + End : Go to last used cell
- Ctrl + Shift + End : Extend selection to last used cell
- Home + Scroll Lock : Move to upper-left corner
- Ctrl + Home : Go to beginning (cell A1)
🔹 Worksheet Navigation
- Page Down : Move one screen down
- Page Up : Move one screen up
- Alt + Page Down : Move one screen right
- Alt + Page Up : Move one screen left
- Ctrl + Page Down : Next sheet
- Ctrl + Page Up : Previous sheet
- Tab : Move right / next unlocked cell
🔹 Miscellaneous
- Shift + F10 or Context Key : Open context menu
Excel extension:
Before 2007, Excel used the .xls binary file format; from 2007 onward, it uses the XML-based .xlsx format.
The maximum number of worksheets in a Microsoft Excel workbook is not explicitly fixed — it is limited only by your computer’s available memory.
Data types:
- By deafult , text are left aligned
- By default, numbers right aligned.
- Date values are treated as numeric . For example if you mention Jan-2019 the backend value will be 1/1/2019(m/d/yyyy)
From the Home tab >>Number group and we can choose different date format or we can create custom one.
No comments:
Post a Comment