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

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Sort by date Sort by votes
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

T
  • Question
Conditional Formatting
Replies
1
Views
91
trevolly
T
W
  • Question
deselecting cells
Replies
1
Views
477
MARK858
MARK858
B
  • Question
Event code to give message box and change color of auto-shape
Replies
4
Views
236
bh24524
B
E
  • Question
Issues When Using VBA to Automatically Move Row to Another Sheet Based On Cell Value
2 3
Replies
21
Views
2K
EBe
E
S
  • Solved
VBL loop help
Replies
3
Views
131
mse330
M

Forum statistics

Threads
1,215,425
Messages
6,124,826
Members
449,190
Latest member
rscraig11

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
Back
Top