Notice that now theres a green triangle in the top-left corner of every cell where youve made this change.The seven features covered here will help you navigate, organize, and readjust your spreadsheet with as little hassle as possible.Split Screen One of the most helpful features for large spreadsheets is the Split Screen command.
The Split Screen allows you to view two, three, or four windows of your spreadsheet. Use this feature to work on one section of your spreadsheet while you view another section; or use it to compare (side by side) two sections of the spreadsheet. Once you try it, youll find lots of reasons to use it. First, position your cursor where youd like the screen to split. For example, if you want to divide the screen into four equal sections, position the cursor in the center of the spreadsheet. Notice the screen splits into four equal sections. If you want to move the split, position your cursor at the apex of the split bars. When the cross with arrow points appears, click and hold, then drag the cross with arrow points across the screen until the screen is divided to your satisfaction. To remove the Split, click View Split (again). People generally freeze frames so they can see the column headers as they scroll down the page, or the first row as they scroll across, as they usually contain the spreadsheets unique fields such as client name, part number, or item number. Use the following instructions to freeze columns A and B (first and last name) and row 1, the field names (column headers). Position your cursor on cell C2. Click View Freeze Frames Freeze Frames. Notice that Excel inserts a thin line below row 1 and to the right of column B. Cursor down, and all the rows scroll up except row 1. Cursor right, and columns A and B are stationary, while the remaining columns move to the left. Excel Remove Double Split Screen In Excel Update The FeesNow when you update the fees in column K, you can see the names of the individuals who owe those fees. Note: You can also choose to just Freeze First Row or Freeze First Column. To unfreeze frames, click View Freeze Frames Unfreeze Frames. For deleting, obviously, you place the cursor on the column or row for deletion. Next you select Home Insert Rows (or Columns ). Home Delete Rows (or Columns, Cells, Sheet ). Another, quicker way to perform this same function: Position the cursor on the column letter (such as column D) or the row letter (such as row 5), and when the black arrow appears, right-click. From the drop-down menu select Insert or Delete, and the columns or rows drop in or disappear instantly. Move your cursor to one or several cells that contain data youd like to move, and select those cells. ![]() When the cursor changes to a cross with arrow points, hold down the left mouse button and drag the cells to the new location, then release the mouse button. Note: You cannot use the bottom-right cell, which has a tiny green square over the corner. This is an access link to the Quick Analysis Tool (notice the icon just below). You know what a hassle it is to constantly format and reformat cells. Use this feature to do it automatically in seconds. Move to a cell that contains the format you want to use (such as K2). Click the Format Painter icon (it looks like a paintbrush) in the Clipboard group under the Home tab. Cursor to the cell, cells, column, or row that you want to copy that format toin this case, currency. Excel Remove Double Split Screen In Excel Plus Sign WithPlace your cursorwhich becomes a fat plus sign with a paintbrush beside iton the first cell in column L (L2), then drag the highlight down through L22 and release the mouse button. Note that all the cells in this column range are now formatted for currency. JD Satain. Click this arrow once, and Excel selects everything, from cell A1 to cell XFD1048576. Typing CtrlA also selects all but, in this case, all means just the cells that contain data. Press CtrlA twice, however, and it selects the entire spreadsheet. Just enter an apostrophe in front of the number; for example: 02120.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |