Excel 2013 - I Need Help With Snap To Cell And Formatting

December 14, 2017 at 08:59:58
Specs: Windows 10, 3 gig
I use Excel professional 2013 at work.
1) How do I turn off snapping to cells. So far, I'm seeing it can't be done? This absolutely drives me insane. I want smooth scrolling because I use a large amount of text in some cells.
2) When I copy and paste a row or column from another book or another spreadsheet altogether, I lose formatting. It changes cell size to a default and I lose font, font size and placement of text location within the cell. I just want it to copy and paste over the way it's copied with all formatting in place. Thanks

See More: Excel 2013 - I Need Help With Snap To Cell And Formatting

Reply ↓  Report •

#1
December 14, 2017 at 16:59:37
I do not use 2013, but is this what your looking for?

https://support.office.com/en-us/ar...

MIKE

http://www.skeptic.com/


Reply ↓  Report •

#2
December 15, 2017 at 05:21:33
No, that doesn't appear to be the same thing. But, thank you.

Reply ↓  Report •

#3
December 15, 2017 at 06:36:32
re: #1:

If snap to grid is not what you are asking about, please provide some more detail. "Snap to grid" was the first thing that I thought of too. What do you mean by "snapping to cells" and "smooth scrolling"?

re: #2

I guess you'll need to explain your process for this one also. I'm running 2010 at work and a simple copy/paste copies all formats whether it's within the same worksheet, the same workbook, a different workbook or even a workbook in a different instance of Excel.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •

Related Solutions

#4
December 15, 2017 at 07:07:09
I found the format option. It's called Format painter. in the upper left hand corner of the home tab. Highlight your spreadsheet that you want copied over, select format painter, click on your new spreadsheet then click in the upper corner to paint the format. Pretty easy to do.

Reply ↓  Report •

Ask Question