Open a new blank Excel workbook [1
9659006] To use with Excel Start, click on the Excel icon on your desktop or in the Start menu. Excel opens with the cursor on option
Blank Workbook .
A workbook is the Excel file. Just click once on
Blank Workbook or press Enter. An empty workbook opens with an empty table. You can add spreadsheets to the workbook by clicking the plus sign tab at the bottom of the workbook viewer. You can also change the order of the worksheets in the workbook by moving their tabs left or right along the tab row. Finally, you can name the tabs and the entire workbook. Setting Up an Excel Spreadsheet: Columns and Fields
The classic spreadsheet format is similar to that of an accountant or accountant. Column letters are at the top (these are the fields) and row numbers at the left (these are records). Remember the traditional calendar format: The days of the week are at the top, and the days of the week that correspond to each day of the week are in the rows below the days of the week.
The fields (or columns) are unique data and can not be repeated, for example: For example, there must not be two Thursdays. The records (or rows) are placed under the columns. In this example, you could have five different days on a Thursday in a month. In a more complicated system, you could have 50 fields with 150 to 5,000 (or more) records in each field.
Each small box in a spreadsheet grid is a cell that can contain numbers and letters, colors, and formulas. Each field, each row, and each record is in its own cell in the Excel spreadsheet.
Each cell is essentially defined by its column letter and line number, e.g. For example, & # 39; cell A1 & # 39; for the cell at the top left. In this earlier story, you'll learn how to navigate the cells of an Excel spreadsheet.
How Excel Ribbons Work
The Excel menus (called Ribbons) are at the top of the screen. The tabs above are the main menus. Click on one of these tabs. The submenus for this tab are shown below. The tabs are highlighted in dark green, and the selected / active tab turns white.
Let's create a very simple worksheet to show how it works.
If you have not moved the cursor since you opened Excel, it is currently in cell A1. If you have moved it, press the
Ctrl + Home1 key to always return to cell A1. Normally, line 1 is reserved for field / column names. So enter the word Paints in A1, press the right arrow and move the cursor to cell B1. Type Colors Right Arrow Press, # Order Right Arrow Press, Cost per Piece Right Arrow, Total Then press the Pos1 .
Note that in column C
# Ordered slips out of cell C1, so to speak. Let's fix the problem.
Hold down the
shift key and then press the right arrow key four times. The shift key anchors the cursor at the current position. Use the arrow keys to select the marker to the end of the desired range.
Start tab and note that six submenus contain the Cells submenu. Click Format and then select Column Width from the drop-down list.
Enter the number
12 in the pop-up box and then click OK . The columns are expanded to 12 characters. Adjust column width and row height in Excel
The default column width and row height settings are 8.43 characters and 15 characters high. If you code these settings hard, you must change them each time you enter a record that exceeds the current column width (or row height).
Use auto-adjustment settings instead. Select the area and select
Format > Automatically adjust column width or Format > Automatically adjust line height .
JD Sartain / IDG Worldwide
set column width + row height
If row 1 is still selected, click the
Home tab again , Note the stacked lines in the Orientation submenu. The automatically selected option that is highlighted is Center, Top Down, as the top row is for vertical alignment. The second row is for horizontal alignment. Click on the middle row of rows in the top and bottom row. The field / column names are centered horizontally and vertically in each cell. Saving an Excel file
File tab and select Save in the page menu, navigate to the location where you want to save this file , name it, and then click Save . When saving a file for the first time, all you have to do is press Ctrl + S to save it again. Other useful keyboard shortcuts for Excel can be found in the past.
Enter data in Excel
When entering data in Excel, always enter from top to bottom and from left to right. Because Excel is essentially the accountant's ledger, accountants always enter numbers from top to bottom. When you press Enter, the cursor moves down to the next cell, not to the left or to the right, because the old calculators worked this way.
Enter five paint companies in column A. five colors in column B; five sets / # ordered in column C; and the cost of each color in column D.
This is where the fun begins.
Enter Formulas in Excel
Excel uses functions that are predefined formulas to calculate the numbers in your worksheets. Fortunately for us all there are over 440, with more being added in each version, not to mention third-party vendors creating add-in programs with their own unique features.
Without these functions, Excel would only be a word processor that creates lists. To learn more about Excel features and formulas, read my previous stories, including an overview of Excel formulas and a guide to the most popular Excel formulas.
JD Sartain / IDG Worldwide
A Basic Basic Worksheet
When you have completed columns A, B, C, and D, position the cursor on cell E2. Enter this formula into this cell:
= SUM (C2 * D2) (the star represents multiplication). Excel calculates the sum of the order quantity and the respective costs.
You can also position the cursor at the location of the cell where the answer should be displayed. Then press the plus (+) key and move the cursor. In cell C2), press the asterisk – to multiply – (then move the cursor to cell D2) and press Enter.
Reposition the cursor in cell E2. Press the copy command
Ctrl + C (a dashed green line revolves around the selected cell like an active marquis). Move the cursor down to cell E3. Hold down the Shift key and press the Down key three times. Then press Enter .
Excel copies the formula in E2 from E3 to E6. Move the cursor to cell A2. Hold down
Shift move the cursor four times to the right and four times down, and then center the text horizontally and vertically in the Orientation submenu on the Start tab ]. Selecting a Cell Range in Excel
You can also use the mouse to select a cell range
(the term that Excel uses to identify a group of adjacent cells). Place your cursor in cell A2, hold down the left mouse button, and drag the marker to cell E6. Then select your options in the Ribbon.
Note: If you buy something after clicking on links in our articles, we may earn a small commission. For more information, see our partner link policies.