Is there any combination of keys to return to the previous cell that the
cursor was last on? For example, I click on a cell to look at the info, the
go a few pages down and click on another cell. Is there a way to get back to
the previous cell my cursor was on?

Returning to the Previous Cell in Microsoft Excel

Yes, there is a simple way to return to the previous cell that your cursor was last on in Microsoft Excel. You can use the Ctrl + Shift + Backspace key combination to achieve this.

Here are the steps to follow:

1. Click on the cell you want to view.
2. Navigate to another cell or range of cells.
3. Press the Ctrl key, the Shift key, and the Backspace key at the same time.
4. This will take you back to the previous cell that your cursor was last on.

Alternatively, you can also use the F5 key to open the "Go To" dialog box. In the "Go To" dialog box, you can select "Last cell" and click "OK" to return to the last cell that your cursor was on.

On 6 Jul., 05:00, Denise <Denise @discussions.microsoft.com wrote:
Is there any combination of keys to return to the previous cell that the
cursor was last on? *For example, I click on a cell to look at the info, the
go a few pages down and click on another cell. *Is there a way to get back to
the previous cell my cursor was on?

Hi

In excel 2000

Ctrl + G (Goto) Special Select last cell Ok

Hope it helps

Regards,
Per

"Per Jessen" wrote:

On 6 Jul., 05:00, Denise <Denise @discussions.microsoft.com wrote:
Is there any combination of keys to return to the previous cell that the
cursor was last on? For example, I click on a cell to look at the info, the
go a few pages down and click on another cell. Is there a way to get back to
the previous cell my cursor was on?

Hi

In excel 2000

Ctrl + G (Goto) Special Select last cell Ok

Hope it helps

Regards,
Per

Unfortunately, select last cell, takes you to the last cell of the
spreadsheet that has data. I need to return to the previous cell that I was
on.

I don't think Excel remembers its previous cursor location, so i don't
think you could do this.

Pete

On Jul 6, 6:17*am, Denise wrote:

Unfortunately, select last cell, takes you to the last cell of the
spreadsheet that has data. *I need to return to the previous cell that I was
on

You can do what you asked for using VBA code and a tool bar button. First,
we will install the code so that it is in place when we add the button.
Press Alt+F11 to take you into the VBA editor. Once inside the editor, look
over at the left side of the screen where you will see the Project Window
and double-click the entry marked "ThisWorkbook". Doing that will bring up
the code window for the workbook itself. Copy/Paste the following code into
that code window....

'*************** START OF CODE ***************
Dim LastCells As New Collection

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, _
ByVal Target As Range)
LastCells.Add Sh.Name & Chr$(1) & Target.Address
If LastCells.Count 101 Then LastCells.Remove 1
End Sub

Sub GoBack()
With LastCells
If .Count 1 Then
LastCells.Remove .Count
Worksheets(Left$(.Item(.Count), InStr(.Item(.Count), _
Chr$(1)) - 1)).Select
Range(Mid(.Item(.Count), InStr(.Item(.Count), Chr$(1)) + 1)).Select
If .Count 0 Then LastCells.Remove .Count
End If
End With
End Sub
'*************** END OF CODE ***************

Now, go back to the worksheet and right-click on any toolbar and select
Customize from the popup menu that appears. Click the Commands tab on the
dialog box that appears, scroll the Categories list down to the Macros item
and click it. In the Commands list, you should see a "happy face" button
labeled Custom Button... click-drag that button onto a toolbar someplace
(the drag-icon will show a plus sign at locations where you can place it).
Next, right-click the "happy face" icon you just placed on the toolbar and
select "Assign Macro" from the popup list that appears. Click on the
ThisWorkbook.GoBack entry and then click the OK button. While you are there,
you can right-click the "happy face" icon again and select "Change Button
Image" to change the happy face to some other image. Once you have finished,
click the Close button on the Customize dialog box and you are done. As you
click around from cell to cell on the current or any other worksheet, those
locations will be stored. Clicking the Macro Button you added will retrace
your path back through the last 100 cells you visited. As you back up
through cells, the cells you back up through are removed from the list...
that is, you cannot go forward through the list again... it is only a
backward-running list.

Rick


"Denise" wrote in message
...


"Per Jessen" wrote:

On 6 Jul., 05:00, Denise <Denise @discussions.microsoft.com wrote:
Is there any combination of keys to return to the previous cell that
the
cursor was last on? For example, I click on a cell to look at the
info, the
go a few pages down and click on another cell. Is there a way to get
back to
the previous cell my cursor was on?

Hi

In excel 2000

Ctrl + G (Goto) Special Select last cell Ok

Hope it helps

Regards,
Per

Unfortunately, select last cell, takes you to the last cell of the
spreadsheet that has data. I need to return to the previous cell that I
was
on.