When working with gridlines, consider the following: By default, gridlines are displayed in worksheets using a color that is assigned by Excel. If you want, you can change the color of the gridlines for a particular worksheet by clicking Gridline color under Display options for this
worksheet (File tab, Options, Advanced category). People often confuse borders and gridlines in Excel. Gridlines cannot be customized in the same manner that borders can. If you want to change the width or other attributes of the lines for a border, see Apply or remove cell
borders on a worksheet. If you apply a fill color to cells on your worksheet, you won't be able to see or print the cell gridlines for those cells. To see or print the gridlines for these cells, remove the fill color by selecting the cells, and then click the arrow next to Fill Color
Note: You must remove the fill completely. If you change the fill color to white, the gridlines will remain hidden. To keep the fill color and still see lines that serve to separate cells, you can use borders instead of gridlines. For more information, see Apply or remove cell borders on a worksheet. Gridlines are always applied to the whole worksheet or workbook, and can't be applied to specific cells or ranges. If you want to apply lines selectively around specific cells or ranges of cells, you should use borders instead of, or in addition to, gridlines. For more information, see Apply or remove cell borders on a worksheet. If the design of your workbook requires it, you can hide the gridlines:
If the gridlines on your worksheet are hidden, you can follow these steps to show them again.
Note: Gridlines do not print by default. For gridlines to appear on the printed page, select the Print check box under Gridlines (Page Layout tab, Sheet Options group).
Follow these steps to show or hide gridlines.
Gridlines are used to distinguish cells on a worksheet. When working with gridlines, consider the following:
You can either show or hide gridlines on a worksheet in Excel for the web. On the View tab, in the Show group, select the Gridlines check box to show gridlines, or clear the check box to hide them. Excel for the web works seamlessly with the Office desktop programs. Try or buy the latest version of Office now. Which of the following statements describes to unhide a hidden row or column?Which of the following statements describes how to unhide a hidden row or column? Select the rows/columns before and after the hidden rows/columns and then right-click and select Unhide.
Which dialogue box is used to transpose rows and columns in MS Excel?Hold down the Ctrl+Alt+V keys (Command+Ctrl+V on the Mac) to invoke the Paste Special dialogue box again. Check the Transpose option and click OK. This will convert the columns to rows.
Which of the following commands is used to increase or decrease a column width?Then click on just the letter R (for the Row option) and the Row submenu appears. Press E and the Height option opens. Enter your choices and press Enter. To change the column width, press Alt+O and then press C (for Column) and then W (for width).
Which of the following consists of details that describe or identify a file including the author?Document properties, also known as metadata, are details about a file that describe or identify it. They include details such as title, author name, subject, and keywords that identify the document's topic or contents.
|