Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel - Cells not "activating" 1

Status
Not open for further replies.
MikeB015

MikeB015

Technical User
Jul 20, 2009
2
US
I use MS Project Server at my job. One of my jobs is to use an option in MS Project, where it takes a project list and exports it to excel. Once there I have to manipulate the data to get the info I need. Unfortunately, none of my conditionals recognize the data in the cells unless I double lick and place the cursur in them. Any idea on how to get all the cells to be "active" and recognizable with out having to open each cell individually?
 
Sort by date Sort by votes
Type 1 (numeral 1, that is) in a blank cell. Copy the cell. Highlight the other cells. Go to paste special; choose Multiply and click OK.

A man has only two choices: He can be right or he can be happy.
 
Upvote 0 Downvote
That worked thanks. Had to change the format because it messed all the dates up but is fine now. Thanks for the help and quick response.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bkoopers
  • Question
Problem with Excel pasting into filtered cells
Replies
1
Views
160
combo
combo
N1GHTEYES
  • Locked
  • Question
Count range overlap cells
Replies
3
Views
436
N1GHTEYES
N1GHTEYES
Swi
  • Locked
  • Question
Excel Webservice
Replies
2
Views
364
mintjulep
M
Kennelbloke
  • Solved
Excel Unique-Filter issue
Replies
3
Views
267
SkipVought
S
renigar
  • Locked
  • Question
Having trouble with Excel Lookup
Replies
5
Views
683
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top