Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
STOP sideways scrolling!! MzDallas Excel Discussion (Misc queries) 4 October 16th 07 03:46 PM
Roll Under- sideways Zygy[_3_] New Users to Excel 2 July 8th 07 01:56 PM
Print sideways W cubed Excel Discussion (Misc queries) 2 January 25th 07 12:46 AM
Sideways filtering Randy Harris Excel Discussion (Misc queries) 1 October 18th 05 12:27 AM
print sideways Dean Excel Discussion (Misc queries) 1 February 18th 05 06:21 PM


All times are GMT +1. The time now is 07:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"