Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding a box sideways
am tring to add a box sideways just in 1 row not all the rows is that poseble ?
when i try it adds a hole colum |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding a box sideways
You cannot. You can insert an entire column or an entire row.
Other options to make it look that way --Enter some data in cells A1:A3 and in cell B2. Select A1:B1 Right clickFormat cellsAlignmentIn 'Text Alignment' under Horizontal select 'Centre across selection' and click OK. Do the same with A3:B3 --Another option is to merge the cells (not recommended due to various reasons) Select A1:B1Right clickFormat cellsAlignmentUnder 'Text control' select 'Merge' and hit OK. -- Jacob "liss" wrote: am tring to add a box sideways just in 1 row not all the rows is that poseble ? when i try it adds a hole colum |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding a box sideways
If you are trying to insert a cell into row 1 and move the other cells
across to the right (or move the other cells down), right click on the cell, click Insert, & then choose "Shift cells right" or "Shift cells down", rather than "Entire row" or "Entire column". Otherwise select the cell, and choose "Cells ..." from the Insert menu to get the same dialogue box. -- David Biddulph liss wrote: am tring to add a box sideways just in 1 row not all the rows is that poseble ? when i try it adds a hole colum |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
STOP sideways scrolling!! | Excel Discussion (Misc queries) | |||
Roll Under- sideways | New Users to Excel | |||
Print sideways | Excel Discussion (Misc queries) | |||
Sideways filtering | Excel Discussion (Misc queries) | |||
print sideways | Excel Discussion (Misc queries) |