• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel Help Please

A

adwilk

Senior member
OKAY, two questions...

Working in a spreedsheet and i'd like to highlight all the cells that contain the value "0". This will help me determine what cells i need to fill in.

Secondly, i'm only doing half the spreadsheet, my partner the rest. We are working on different machines at the same time. The sheets are identical except that he is doing some of the entry and i'm doing the rest. HOw can we "merge" the two so that one of us doesnt have to re-enter the info?

Thanks for the help. Hope this all makes some sense. PLease let me know if you have any questions...
 
Okay, well it seems that conditional formatting takes care of my first issue, i always forget about that... so any advice on my second issue...
 
Our Computers arent networked... Does this matter? By the way, WE are both done with our parts... now how to make them one??? hopefully there is a shortcut?
 
Whoops, blank reply.

Can you do it this way?

On the second copy of the spreadsheet, select everything and copy it. On the first copy, right click, paste special, and tick the "skip blanks" box.

I just tried that with excel here. I made one column with numbers in it, with a few blank rows here and there. I made a second column with numbers in the rows that were blank in the first column. Copy the second column, click the top of the first, and paste special/skip blanks. That merged the data from the two columns together.

As always, save before trying something like that. Maybe even make a backup copy of both spreadsheets.
 
Originally posted by: MrBond
Whoops, blank reply.

Can you do it this way?

On the second copy of the spreadsheet, select everything and copy it. On the first copy, right click, paste special, and tick the "skip blanks" box.

I just tried that with excel here. I made one column with numbers in it, with a few blank rows here and there. I made a second column with numbers in the rows that were blank in the first column. Copy the second column, click the top of the first, and paste special/skip blanks. That merged the data from the two columns together.

As always, save before trying something like that. Maybe even make a backup copy of both spreadsheets.
Click to expand...



Works like a charm... thank you...
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top