deselecting cells when switching between sheets

D

dhughes85

New Member
Joined
Apr 10, 2015
Messages
19
this is a really basic question so apologies.

when moving between sheets the cursor selects a cell (usually A1)... is there some way to stop is auto-selecting a cell so that nothing is highlighted? I'm running Excel 2007
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Sort by date Sort by votes
Joe4

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
68,031
Office Version
  1. 365
Platform
  1. Windows
Not that I know of. It usually selects cell A1, or whatever the last cell selected on that sheet was.

You could add VBA code to have it always select a specific cell, but I don't think it is necessary to have an Excel sheet up and no cell selected at all.
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question
Help ensuring ActiveX combobox stays on one sheet
Replies
5
Views
407
Everettexcel
E
M
  • Solved
Using = to copy info from a cell to another sheet, but the 2 sheets have different layouts
2
Replies
15
Views
589
Fluff
Fluff
S
  • Solved
Move to next cell when value reached
Replies
3
Views
1K
Sheene1976
S
E
  • Solved
Move cells to another sheet based on criteria + Auto-sort
Replies
7
Views
636
ebcopystop
E
C
  • Solved
How to easily distinguish between formula cells and value cells?
Replies
3
Views
656
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,195,643
Messages
6,010,889
Members
441,571
Latest member
stolenweasel

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top