Cell font and font size

teza2k06 · #1 02-09-2014, 06:39 AM

Hi All,
Sorry for all the questions, but i should be pretty much sorted with my spread sheet after this last problem (fingers crossed)

I am re-doing a spread sheet for work which we always use, We are forever copying and pasting information in to the spread sheet, but it is starting to look a mess as the fonts and sizes are all different.

Is there a way i can set all the sheets and specific cells to stay at a certain font and size, so that when we are also copy information into it the row height stays the same, and the font and font size will change to whatever it is set at?

This way everything looks the same, and the spreadsheet stays neat and tidy

Any help will be appreciated

Thanks all

excelledsoftware · #2 02-09-2014, 09:07 PM

One way you could do it is to have them paste just the text each time. I wrote this code a little bit ago for this purpose. It recognizes if the text they are pasting is from Excel or another source. you could assign this to button or autoshape and then they can just click that button rather than CTRL V or right click then paste.

Code:

Sub PasteText()
    On Error GoTo valueerror
    ActiveSheet.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:= _
        False
End
valueerror:
On Error GoTo clipboardempty
        Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    End
    
clipboardempty:
MsgBox "Nothing on clipboard to paste."
End
        
End Sub

jamesdann · #3 02-10-2014, 04:04 AM

First of all set a particular font and font size for your spreadsheet. After that go to the paste button and choose Paste Special option, now uncheck the paste all, Formulas and Format option from the pop up menu. Now you can paste your information as it is already set in your spreadsheet.

macropod · #4 02-10-2014, 11:09 PM

Instead of copying & pasting, simply making the output value the same as the input value transfers the data without changing the destination format. It's also far more efficient.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word will not hold settings, such as font and size of font	Mary M	Word	1	10-12-2013 07:41 AM
Font Size	cjpga	Outlook	1	04-13-2013 06:45 AM
how change size font to inches size	kkepo	Word	4	08-28-2012 08:53 PM
Cursor size varies with font size	r_lewis@fuse.net	Word	0	07-20-2011 06:11 PM
Font Size	iflog	Outlook	1	11-30-2010 09:33 PM