Excel 2013 :: Inserting Link In Cell Changes The Default Font Type And Size?
Feb 23, 2014I used Excel 2013 and Win 8.1
When I insert a Hyperlink in a cell, this changes the Default Font Type and Size
ADVERTISEMENT
Clear All Versus Default Font Size
Jun 17, 2013I'm currently having an issue with Clear All... which sets the font to Tahoma, size 11. Font is okay, but I have my default size set to 10. Everytime I Clear All on even a single cell, the row size increases from 13.50 to 14.25 (from 17 to 20 pixels).
View 9 Replies View RelatedExcel 2003 :: Font Size Dependent On Cell Value (not Using Conditional Formatting)
Nov 28, 2012Excel 2003.
I am creating a heat map using two variables from a questionnaire: firstly the number of people impacted by a question; and secondly, the level of the impact. Respondents are asked to give these values in two adjacent cells. These are then multiplied to give a weight eg 1000 people x level 3 impact = 3000. I have used Conditional Formatting to colour the cell according to the impact level (0 = none - white (default), 1 = moderate - tan, 2 = significant - orange, 3 = high - red). What I want to do is then change the font size to give an indication of the number of people impacted, eg 1 - 1000 font 8, 1001 - 3000 font 12, 3001 - 8000 font 16, 8000 - 2000 font 24 etc. The size of font and colour will then represent the number of respondents and their impact.
I can't use Conditional Formatting as the value of 3000 could be derived from 1000 people at level 3 (red), or 3000 people at level 1 (tan). Is there another way of setting the font size depending on the cell value, eg by VBA?
Excel 2010 :: Inserting Image To Cell / Merged Cells As Background Fixed To Cell Size?
Jan 18, 2014Excel 2010. I need to place picture into one cell or one big merged cell, as a background fill. picture must resize to size of cell. must be fixed in, not in front. i still need write into that cell, so it needs to be really background.
View 2 Replies View RelatedExcel 2013 :: How To Restore Default VBA Libraries
May 21, 2014Any way to restore the default reference libraries that are checked the first time you open Tools => References in VBA in Excel 2013. I think I accidentally unclicked something that's necessary to run the program, and I can't find a "default restore" option or anything of that sort.
View 8 Replies View RelatedExcel 2007 :: Default Chart Size?
Jan 6, 2014I have excel 2007 and I came across the following difficulty:
If I create a graph (or a chart) the default size is "Letter". However, I can switch this "Letter" to "A4" which I need and then create a template. But I always have to manually choose this template for new charts. However switching this any time I create a new chart is a rather bad way to cope with. Even clicking on set as default obviously does not cause to have A4 size for new chart, it still has got size of Letter when adding a new chart.
I assume the solution could be in XLStart templates, but it probably doesnt work for charts that you add. Or at least I didnt find any clue on the internet for this problem.
Excel 2013 :: Define Font Colour Within Macro
Apr 3, 2014Excel 2013
I am trying to define a font colour within a macro When I record the macro, I choose a colour from the font colour-picker in the Home section of the ribbon. The colour I choose is one of the grey shades Everything seems to work ok, and the macro saves with the colour defined as a long number, e.g.
.Bold = False
.Italic = False
.ThemeColor = xlThemeColordark2
TintAndShade = -0.499984740745262
(Note this is the colour number returned by Excel when I chose a grey font) But when I run the macro, instead of a grey font I get a sort of pale apricot
Do I need to re-index something?
Is there a list anywhere of these long numbers and the colours that they represent?
Default Excel File Type When Opening?
Mar 21, 2014is it possible to change the settings on your computer so that when you open Excel, it opens it as a certain type of file? I like working with .xlsb because I work with large sets of data all of the time and find that they open faster and are faster to work with. Currently every time I open Excel, it opens as .xlsx.
View 1 Replies View RelatedExcel 2010 :: Change Font Size In A Checkbox?
Jan 30, 2013How do you changethe font size in acheckbox in excel 2010?
View 1 Replies View RelatedExcel 2013 :: Inserting Table In Form
Feb 7, 2014I just discovered forms in excel and loving what custom functionality you can create with it; however, I need to include a table into the form but I've come to a road block. I don't see a way possible to render data from a query into a table inside of a form.
PS - I'm using Excel 2013
Comparing Two Cells Based On Text, Font, Colour, Font Size Etc
Jun 3, 2006I'm looking to set up a spreadsheet whereby individuals answer questions and have to format their answer using a particular font, colour, font size and so on. The idea is that I can then compare their answer sheet to a pre completed one using an =IF function and get a total score. The only problem is =if and =exact only lookup cell text/numbers and don't look at how the text is formatted within them.
View 9 Replies View RelatedExcel 2010 :: Removing Text From Mixed Font Size Cells
Aug 4, 2012I have text of size 14 and 18 mixed in cells in a column. Cells are font size 18 or mixed with both 14 and 18 size text. I need to sort out the text with one column of size 14 and another of 18 only. I am thinking of copying and pasting the column twice and run a macro in first column to remove the text of size 14, and another macro to delete text of size 18 in second column. I need the leftover text to be in same rows.
I tried everywhere and couldn't find a macro for mixed text cells. I am using Microsoft Excel 2010.
Excel 2013 :: File Size Grows When Using Macro To Copy / Paste To New Workbook
May 9, 2014I'm using Excel 2013 on Windows 7.
I have an Excel file which has a macro that sucks in data from a number of separate files (two Excel, a varying number of csv). The macro grabs all the individual files and loads them into one of three worksheets with some formatting, sorting, and structuring on the way. All good so far.
I then need to take two of the worksheets and copy them to a new Workbook which I can send out to some users. So I use the Workbooks.Add method, and use the Selection.Copy on just the data (UsedRange.Rows/Columns.Count to ensure it is only the data) and Selection.PasteSpecial with the xlPasteColumnWidths, xlPasteValues, and xlPasteFormats options to copy the data over. None of the data is filtered. Just straight data.
I would expect the newly added workbook to be smaller than the one with the macros because the one with the macros has two extra sheets that I don't transfer, and the sheets I do transfer are identical.
And that's where it gets weird. The file with the macros and more data is 18.7Mb, but the new one with only two sheets is 24.8Mb. One is .xlsm and the other is .xlsx (because it has no macros).
I've tried opening the new workbook and saving as .xlsm (no material difference to the size) and as .xls (it got even bigger). I've opened the new workbook, gone to the end of the data and deleted all the blank rows and columns, but no effect (because the rows are already empty).
Why would the file with less in it be so much bigger (or bigger at all)?
Cell Bold And Font Size 12 And Highlight In Red
Mar 6, 2008I am using this formula (Below) and it is working great. Only problem is that I want the client name to be be bold and font size 12, then I want it to highlight in Red. I also want the rows in colunm L to highlight in bright green.
Sub InputData()
Dim varUserInput As Variant
Dim LastRow As Integer
LastRow = Cells(Rows.Count, "G").End(xlUp).Row + 1
varUserInput = InputBox("Enter client name:", _
"Client Name", "")
If varUserInput = "" Then Exit Sub
Range("G" & LastRow).Value = varUserInput
Range("G" & LastRow + 20).Value = "Total".......................
Changing Default Font And Cell Sizes In New Workbooks / Worksheets
Mar 17, 2012How to change these defaults...
It involved opening a new workbook and changing the number of worksheets in a new workbook, cell sizes, font, and font sizes... and then saving the workbook in one of the system folders under the name "workbook" to change the default workbook attributes, or "worksheet" to change default worksheet attributes.
Change Font Type Based On Cell Value
Aug 25, 2014I have a workbook that includes a drop down list with three options. One of the options is "TA". The default font type for these cells is "Wingdings" but when "TA" is chosen I want the Font Type to change to "Arial".
View 11 Replies View RelatedChange Cell Font Type If Condition True
Apr 26, 2008I would like to know if there is a way to change the font type in a cell, if a condition is true in another cell. e.g font in cell C3 is Arial Rounded MT Bold and if condition is true in cell F3 then font is changed to Arial Narrow.
View 8 Replies View RelatedUse Conditional Formatting To Change Font Size Based On Value Of Cell?
Jul 18, 2013I am trying to set up conditional formatting in cell C4 to change the font to a smaller number based on the value of C4. If C4 = 0 then Font Calibri 16, otherwise Font Calibri 24. However, the font size is not availabe, it is greyed out. Is there another way to accomplish this without using VBA? In the worksheet could I use an if() statement to change the font size?
View 6 Replies View RelatedExcel Save As Should Default File Save Type To XLSX Using VBA
Aug 21, 2012What I am trying to do is that I have an excel file with macros and it is a read-only file. In order for the user to save, I want them to only be able to save as a .xlsx file as it disables all macros. If for whatever reason, the user wants to save the file as another .xlsm file, they should be allowed but before they save, a "are you sure you want to save as .xlsm?" message should pop up.
All the options in the save as box should still be available in case they want to save in that particular format. Just that the .xlsx should be the default.
Change Size Of Tab Font
May 7, 2009Somehow my tab names (in 2003) have a very small font size. How do I return the size to normal?
View 5 Replies View RelatedInconsistent Font Size?
Jun 10, 2013I have my Excel set up for a default font size of 12 point.
I often download CSV data to insert into spreadsheets. It opens in a new spreadsheet, and it's properly displayed in 12 point size. When i copy and paste it into the ultimate target spreadsheet (which is also set to 12 point size) the pasted data shows up as 10-point and I have to change the font size back to 12-point every time.
Why is this happening and how can I avoid that re-sizing that occurs?
Linking Font Size Changes
Jan 13, 2009This probably sounds really weird, but does anyone know whether the size of the text in Cell A1 on Sheet 1 can be linked to the size of the text in Cell B2 on Sheet 2? Like, when I change the size of Cell A1's text, is there a way to have the size of Cell B2's text change as well?
View 8 Replies View RelatedDrop-down Box Font Size
Mar 18, 2009I currently have an Excel spreadsheet already created. I have added drop down lists using the Validation>Data feature and can get this to create the drop-down box, but the font is unreadable. If I create a new sheet and create the drop-down list it becomes readable. I can't figure out why the first is unreadable due to its small size. I eventually plan to add formulas to calculate how many yes's or no's in a column, but will address that later. I use Excel 2003.
View 9 Replies View RelatedChange Default Text/Font Color
Apr 16, 2008I was just wondering how I can type in a different colour. I.e. I have a document and I want to type in random cells but I always want to be typing in red, or blue etc. Hoe can I change the default text color?
View 8 Replies View RelatedChange Default Comment Box Size
Oct 14, 2009I need to default size to be bigger. Is there a way to do this so I do not need to re-size the box every time?
View 2 Replies View RelatedSet Default File Type (non Standard)
Jan 26, 2010I cant seem to get the file filter to be what I want. I want to et the default file filter string to "MOT*.xls". With the code below I get "*.*" and no option for my own filter value.
View 6 Replies View RelatedSliderBar To Control Font Size?
Jan 11, 2013Is it possible to control the font size in a cell with a sliderBar?. I have a template I use to print labels on cd sleeves and need to change the font a lot. Looking for a fast and easy way,seems like a sliderbar would be easy.
View 2 Replies View RelatedHow To Adjust The Font Size In A Comment
Oct 26, 2013Is there a way to adjust the font size in a comment. The default seems way to small. All thoughts on the subject .
View 4 Replies View RelatedConditional Formatting Font Size?
Nov 24, 2013I want to change Font Size ,when Conditional formatting is used in a range.
I know , it is not possible with conditional formatting basic application.
I need a macro code, if possible to do it.
Drop Down List Font Size
Jul 28, 2007How do you increase the font size of a drop down list in excel apart from zooming in. I have 10 dropdwnbxs each with about 16 items.
Everything works fine but users can not see the contents of each drop down box(fonts are too small). Is there a solution to this? (or just keep zooming in/out). Example i have a drop down box in A2 with source from F2:F17.....etc
How can i increse the font size?
