Active5 years, 1 month ago
A style is a set of formatting characteristics, such as font name, size, color, alignment, and spacing. When you want to apply more than one format at a time to a cell or range of cells, it is easiest to apply a style. When using microsoft excel some of my text disappears. I tried to put in dates in the cell and it disappear - Answered by a verified Tech Support Specialist. When using microsoft excel some of my text disappears. I tried to put in dates in the cell and it disappear when i went to the next cell. The Expert answered my Mac question and was. Within excel you can conduct calculations on multiple worksheets and workbooks open at the same time. Each workbook acts as its own separate window on your PC or Mac, while each worksheet acts as.
In Excel, I want to make the text of a cell disappear if the adjacent cell is blank. Or the reverse: when text is entered into a cell, a specified number appears in the adjacent cell.Ex. When any text is entered into A4, the number 43210 appears in cell B4.
Brian CattellBrian Cattell
2 Answers
Mark BakerMark Baker185k2525 gold badges290290 silver badges350350 bronze badges
You could also use conditional formatting, stablishing a rule that sets text colour to white using the formula
=$A4<>'
on cell B4
NuTTyXNuTTyX
Not the answer you're looking for? Browse other questions tagged excel-formula or ask your own question.
In Excel, borders are lines added to the edges of a cell or group of cells. The line styles that can be used for borders include single, double, and broken lines. The thickness of the lines can vary, as well as the color.
The information in this article applies to Excel versions 2019, 2016, 2013, 2010, and Excel for Mac.
About Borders in Excel Worksheets
Borders are formatting features used to improve the appearance of your worksheet. Borders make it easier to find and read specific data. Borders also draw attention to important data, such as the results of formulas.
Add Borders Using a Keyboard Shortcut
If you prefer to work with your keyboard, use a keyboard shortcut to add a border to the outside edges of one or more selected cells. This shortcut uses the default line color and thickness. The key combination to add a border is:
To add a border to a range of cells within an Excel worksheet:
- Highlight the desired range of cells in the worksheet.
- Press and hold the Ctrl and the Shift keys.
- Press the & key without releasing the Ctrland Shiftkeys to surround the selected cells by a black border.
Add Borders in Excel Using Ribbon Options
The Borders option is located under the Home tab and can be used to add custom borders to cells in your worksheet.
To add a custom border:
- Highlight the desired range of cells in the worksheet.
- Select Home.
- Select the Bordersdown arrow to open a drop-down list of border options.
- Choose a border style. The chosen border appears around the selected cells.
Choose a Variety of Border Options
When you're ready to add and format lines and borders in an Excel worksheet, you have several options:
- Add borders to one or all sides of a cell or block of cells.
- Choose a line thickness.
- Select from a variety of line styles.
- Apply a color to a border.
- Draw borders around irregularly shaped blocks of data with Excel's Draw Border feature.
Draw Border Lines Quickly with the Draw Border Feature
The Draw Borderfeature is located at the bottom of the Borders drop-down menu. One advantage of using Draw Border is that it is not necessary to select cells first. Instead, once the Draw Border option is selected, borders can be added directly to a worksheet.
Draw Border also contains options for changing the line color and line style. This makes it easy to vary the appearance of borders used to highlight important blocks of data. The line style options allow you to create borders with:
- Lines of varying thickness
- Dotted and dashed lines
- Double lines
To draw border lines with the Draw Border feature:
- Select Home.
- Select the arrow next to Borders to open the drop-down. From this list, you can choose a different line color, change the line thickness, and draw border lines around cells.
- Select Line Color and choose the color you want to use for the border.
- Select Line Style and choose the line thickness you want to apply to the border.
- Select Draw Border. The mouse pointer changes into a pencil.
- Select the side of individual cells where you want to add a single border.
- Drag with the pointer to add an outside border to a cell or group of cells.
Draw with the Border Grid
Another option on in the Borders list is Draw Border Grid. With Draw Border Grid, you can add outside and inside borders to one or more cells at the same time. Select Home > Borders > Draw Border Grid and drag the mouse pointer to create borders around the desired cells.
Stop Drawing Borders
Excel Title Cell Style
To stop drawing borders, select Borders. Excel remembers the last type of border you use, so selecting Borders again re-enables that mode.
Heading 2 Cell Style In Excel
![For For](/uploads/1/2/6/8/126888713/887387066.jpg)
Erase a Border
How To Apply Title Cell Style In Excel
The Erase Border option, as the name suggests, makes it easy to remove borders from worksheet cells. Erase Border allows you to remove border lines individually by selecting them. You can remove multiple borders by dragging across those cells.