Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rows
1) How do I insert mutiple rows without using the Insert -- Rows mutiple
times? 2) How do I move an entire row from 1 place to another on the same worksheet? 3) How do I shift an row a fixed number of cells to the left or right? Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rows
On Mon, 6 Jul 2009 15:28:01 -0700, PL
wrote: 1) How do I insert mutiple rows without using the Insert -- Rows mutiple times? 2) How do I move an entire row from 1 place to another on the same worksheet? 3) How do I shift an row a fixed number of cells to the left or right? Thank you 1) Inserting multiple rows: See http://excel.tips.net/Pages/T002339_Inserting_Rows.html 2) Move an entire row: See http://office.microsoft.com/en-us/ex...014641033.aspx 3) Shift cells: See http://www.dummies.com/how-to/conten...xcel-2007.html and http://uk.answers.yahoo.com/question...0161901AAwIW3j Hope this helps / Lars-Åke |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rows
Hi,
Lets deal with question 3 first. You can't shift an entire row left or right. 1. Click the first row number you want to insert and hold down the Ctrl key and click all the other rows you want to insert. Then press Ctrl++ (control plus). 2. Select the row number you want to move and hold down the Shift key, place the mouse along the border of the selection and when you see a 4-headed arrow, drag up or down. Release the mouse first. 3. If you want to shift "cells", not a row, left or right - select the cells and press Ctrl++ (control plus) or Ctrl+- (control minus) and response Shift cells left or right. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "PL" wrote: 1) How do I insert mutiple rows without using the Insert -- Rows mutiple times? 2) How do I move an entire row from 1 place to another on the same worksheet? 3) How do I shift an row a fixed number of cells to the left or right? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting characters in multiple rows when rows meet specific criteria | Excel Worksheet Functions | |||
Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) | |||
Copying multiple rows to other worksheets (but amount of rows varies) - How? | Excel Discussion (Misc queries) | |||
Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions |