5/15/2023 0 Comments Microsoft excel for dummies![]() With selected columns or rows, clicking the Insert or Delete options in the right-click menu will either add or remove columns or rows in the same quantity selected. The options displayed are directly related to the object you have right-clicked on. When you right-click a cell, you will receive a menu of options. NOTE: If you want to see a demonstration of many of the most popular Excel keyboard shortcuts, check out this post and video: With the column selected, holding the Shift key while repeatedly pressing the left/right arrow keys will select multiple adjacent columns. One of the best shortcuts for selecting columns is CTRL-Space. Shortcuts GaloreĮxcel has more shortcuts than probably anyone knows ( at least anyone with a social life.) To select multiple rows or columns, click and hold the first row/column, then drag across the adjacent rows/columns until you have selected all the needed locations. To select a row or column, click the applicable row or column header. You can also press the CTRL-Home keys to instantly relocate to cell A1. To return to the “beginning” of the sheet ( upper-left corner of the sheet) enter the cell address A1 into the Name Box and press Enter. Try the following cell address to see the end of the spreadsheet universe ( lower-right corner of the sheet.) ![]() This will instantly relocate you to the new cell. When you need to position yourself in a cell that is a considerable distance from your current location, you can type the address of the destination cell into the Name Box and press Enter. This will make it easier to accurately determine the address of the selected cell, especially if you happen to be zoomed out to a point where reading the row and column headings become difficult. One purpose is to display the address of the currently selected cell. Performing the edits in the Formula Bar will prove a much easier task.Ī cell containing numbers or text will display the same information on the Formula Bar as is displayed in the cell.Ī cell that contains a formula will display the formula in the Formula Bar and the formula’s result in the cell. The Formula Bar is where formulas, numbers, or text can be edited after being placed in a cell.Īlthough you can edit the contents of a cell directly on the grid, this becomes more challenging when working with complex formulas or long passages of text. The address is a composite of the cell’s column position ( a letter) and the cell’s row position ( a number). If the cell contains information, that information will be replaced with the newly entered data.Įach of the over 17 billion cells on a sheet has a unique address. If the cell began as an empty cell, the newly entered data will be displayed. To enter information into a cell, click on the desired cell and start typing. This means you can place over 17 billion pieces of unique information on a single sheet. Where these rows and columns interest we have what are called cells. The Layout of the GridĮach sheet in a workbook is composed of a series of rows and columns. ![]() You can rename a sheet by double-clicking on the sheet tab to enable rename mode. A workbook consists of at least one sheet.Īdditional sheets can be added by clicking the “ plus” button to the right of the sheet tabs. You can also use the keyboard shortcut CTRL-S.Ī single Excel file is often referred to as a workbook or spreadsheet. To save the workbook, click the Save button in the Quick Access Toolbar ( upper-left corner), provide a name and location to save the file, and click Save. When you begin with a new, blank workbook, the workbook is not saved until you initially save the file. This is useful for files you may have downloaded from email attachments or recently gained access to via a USB device. This is a convenient way to open a file you have been working on in the recent hours or days without having to manually locate the file.
0 Comments
Leave a Reply. |