Some general questions about excel

  • Thread starter Thread starter Julie P.
  • Start date Start date
J

Julie P.

Does anyone know:

1) How to "fill left" and "fill up"?
2) How to "shift cells left" when inserting a group of cells?
3) How to have "always create back-up" selected as a default option when you
create a new Excel worksheet? Right now, if I "save as", this option is
checked, but not when I do "new".

Thanks for your advice!

Julie
 
Hi Julie

can help with #1 - check out Edit / Fill ... options are there for left & up

Cheers
JulieD
 
JulieD said:
Hi Julie

can help with #1 - check out Edit / Fill ... options are there for left &
up

Cheers
JulieD
Click to expand...


oh, duh! thanks Julie! I guess what threw me was there was no key command to
do those, so I never noticed the other choices in the menu!
 
Julie,

'Help' with #2 - you can't "shift cells left" when inserting cells, (if that
is any help?), where would they go to? In the same way if you have data in
column IV you cannot insert cell and shift cells right, you get a "To
prevent possible loss of data, Microsoft Excel cannot shift non blank cells
off the spreadsheet" message.

Regards

Sandy
 
Sandy Mann said:
Julie,

'Help' with #2 - you can't "shift cells left" when inserting cells, (if
that
is any help?), where would they go to? In the same way if you have data in
column IV you cannot insert cell and shift cells right, you get a "To
prevent possible loss of data, Microsoft Excel cannot shift non blank
cells
off the spreadsheet" message.

Regards

Sandy
Click to expand...


Hi Sandy, thanks for your reply. What I mean is if I have a blank column
directly to the left of where I want to insert a range of cells, sometimes I
want to shift the affected cells to the left, to take up the space in that
blank column to the left. I hope this makes sense.

J.
 
Hi Julie

you'll need to move the contents first (if you select the range, move your
cursor over the active border and when you see a white arrow hold down your
left mouse you can drag the cells to the new location) and then insert the
new cells.

Cheers
JulieD
 
Or you can do it with a Macro:

Sub InsertToLeft()
Application.ScreenUpdating = False

With ActiveCell
If Cells(ActiveCell.Row, 1).Value <> "" Then
MsgBox "There is data in the 1st cell!"
Application.ScreenUpdating = True
Exit Sub
End If
.Insert Shift:=xlToRight
End With

With Cells(ActiveCell.Row, 1)
.Delete Shift:=xlToLeft
End With

Application.ScreenUpdating = True
End Sub




HTH

Sandy
 
Back
Top