• 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.

Quick question for the Excel gurus

A

Arkitech

Diamond Member
Ok, here's what I'm trying to do: I have data that I'm attempting to copy from one worksheet into another. But whenever I paste the old cells into a new worksheet everything resizes so I have to manually go in and resize the cells so that the data can be read. Is there a way I can copy over the cells so that they automatically keep the original size?
 
right click on the worksheet name, select move or copy, then check "create a copy"

bam - new worksheet that is identical

 
You can also highlight the entire sheet that you cannot read and click in between 2 columns at the top, it will auto format so all the cells are large enough to read but it can suck if you have entire sentences in a cell.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top