Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-12-2010, 06:47 PM
pavamaklava pavamaklava is offline ms office excel 2007 cell selection issues Windows 7 ms office excel 2007 cell selection issues Office 2007
Novice
ms office excel 2007 cell selection issues
 
Join Date: May 2010
Posts: 1
pavamaklava is on a distinguished road
Default ms office excel 2007 cell selection issues

hello.



when you click on a cell, and then hold shift and click on some other cell, it will select a "path" of cells from the first to the last. the first cell (i will call this the "primary cell") is special in that if you hold shift down again, and click on another cell, it will change the path of selected cells as well as the last selected cell. however, when you move the entire group of selected cells, excel will change the *relative* location of the primary cell. how to prevent this from happening?

also, suppose your spreadsheet, for some reason, has 20000 rows, and the bottom 19000 rows are empty. how can you configure excel so that the spreadsheet only has 1000 rows (i.e. if you scroll to the "bottom", the row number is about 1000)?

thanks!
Reply With Quote
  #2  
Old 05-12-2010, 10:47 PM
ConneXionLost's Avatar
ConneXionLost ConneXionLost is offline ms office excel 2007 cell selection issues Windows XP ms office excel 2007 cell selection issues Office 2003
Simulacrum
 
Join Date: Jan 2010
Location: Victoria, Canada
Posts: 86
ConneXionLost is on a distinguished road
Default

Hi,

What you call the "Primary" cell, is usually referred to as the "Active" cell. As you've discovered, you can have a selected cell, or a range of selected cells. If you select a range or block of cells (with the Shift key), the active cell will remain as the active cell, and even allow you to type in it without losing your selected range. As an experiment, select a range of cells, then hold down the enter key. You should see the active cell cycle through the selected range. As long as the range is not moved, the active cell will maintain it's relative position in the range. However, the moment you "move" a range, the current/relative active cell position is lost, and it resets to the upper left corner of the range you are working with.

Some Excel events (typing) will only affect the active cell, others (formatting) will affect the selected range.

As far as I know, the behaviour and relationship between the active cell and the selected range is part of the inherent programming within Excel, and cannot be changed.

Cheers,
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
ms office excel 2007 cell selection issues Excel 2007 cell format help!!! Raner Excel 4 06-17-2013 11:13 PM
ms office excel 2007 cell selection issues Excel printing issues kns Excel 2 05-01-2010 02:04 PM
Example req for VBA app in excel 2007 (for Office 2007) aligahk06 Excel 0 08-28-2009 04:36 AM
Splitting Excel cell into multiple ruben23 Excel 1 07-23-2009 03:49 AM
ms office excel 2007 cell selection issues compatibility issues between 32-bit office and 64-bit system? bratwursty Office 1 05-13-2009 03:11 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 05:21 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft