Revert (Bold) Underline Back To Normal

Jan 12, 2014

What I mean by my "bold" underlines:

QRG5UUl.png

Notice the difference between the bold underline and the normal ones. There is also some weird thing happening where in some cells, when I use the underline feature, it shows as a bold underline, but once I've pressed enter to move on to another cell, the underline reverts back to normal. If I select to edit (F2 or double-clicking) said cell, the underline becomes bold, and vice versa (s3lw.png).

All this started happening immediately after I did this (was just experimenting, and I have no idea what this actually does, or if it was the cause of those occurences): Insert > Symbol > Special Characters > No-width optional break. I did that to just one cell though, and now all this weird stuff is happening.

View 4 Replies


ADVERTISEMENT

Bold, Underline And Italic Greyed Out

May 8, 2009

My spreadsheet is locked and protected, and i have found out that the BOLD, underline and italic functions have been disabled, is there anything i could do via VBA to keep these functions active,...????

View 4 Replies View Related

BOLD And UNDERLINE Concatenated Cells

Apr 23, 2006

I need bolding and underlining cells that are "Concatenated". For example, cell format for cell K12 is already bolded and underlined. If I concatenate (C1,K12,D2) I get a result that doesn't carry over the format of those individual cells - particularly K12 which I want BOLDED and UNDERLINED.

View 9 Replies View Related

Excel Custom Format A Value With Bold And Underline

Sep 26, 2011

The formula is ="Total: " &SUM(B2:B10) Can you make the result appear bolded and underline. Just the result from the =SUM formula not the text Total.

View 1 Replies View Related

Format String Text - Underline Or Bold

Jul 23, 2012

Can Excel format text in a formula?

i.e.: =if(R25>6"This is Simple test", "This is the other part part of the test")

and then underline the word "Simple" or to have the word "other" bold.

View 4 Replies View Related

Split Name Into Two Variables And Revert Back To Same Name

Aug 10, 2012

I have a query where the correct name is mixed up by each single click of a button and finally the mixed characters reverts back to correct name. I will give the examples below.

1) Beautiful --> next click of a button
2) utifulBea --> next click of a button
3) Beautiful --> the final output will be back to same name.

View 3 Replies View Related

Cells Revert Back To Letters Instead Of A Symbol

Sep 7, 2009

The code brings up the message box the way I need it to

At the bottom of the code in the standard module is what I changed.
In the message box. If the GDT button is clicked the GDT chart opens. If the Symbol button is clicked the Symbol chart opens. This all works.

But will I select a symbol from the symbols chart it will appear in the cell that is double clicked. but then end up as a letter instead of a symbol.

But, the gdt chart works perfect.

I thought Cancel = True Would do the trick but does not. Any ideas what is missing??

This code below is in the sheet module

Private Sub Worksheet_BeforeDoubleClicK(ByVal Target As range, Cancel As Boolean)
ThisWorkbook.Unprotect
ActiveSheet.Unprotect
With Application
Cancel = True............

View 9 Replies View Related

Excel 2010 :: After Applying A Data Filter And Sorting The Data / How To Revert Back To Original

Dec 20, 2012

I'm using Excel 2010 and I applied a Data Filter to a simple table. I then messed around with the drop downs in each column, sorting the data by different criteria. After doing this, is there a simple way to get the table to revert back to its original order/form?

View 3 Replies View Related

Merging Cols Changes Bold To Non-bold Or Non-bold To Bold

Jun 8, 2008

I am merging columns. Col B has all text in bold. Col C has all text in regular font. When I use ASAP to merge, the merged column comes out all bold. When I use a formula to merge the merged column comes out all regular. What I want is for the merged column to contain the bold text from Col B in bold, and the regular text from Col C in regular.

What I want is...

This is for service plan B: Take all data and transer to new server.

What I am getting is...

This is for service plan B:Take all data and transer to new server.

OR

This is for service plan B:Take all data and transer to new server.

View 9 Replies View Related

How To Run Macro If Selection Is Not Bold And If Bold Then Do Nothing

Aug 5, 2012

How do we run a macro if the selection is not bold and If bold then do nothing.

View 3 Replies View Related

Make 1 Cell Bold If Another 1 Is Bold

Oct 2, 2007

I am trying to create a macro that if a value in a cell in column A is bold, then the value in the same row in column H is bold, then loop it to run on the rest of the worksheet.

View 9 Replies View Related

Revert To Week Commencing

Apr 16, 2014

If my week commences on Saturday 16th Feb (A2), but I do some training on 22nd February (B2), how do I C2 to show the first day of theweek it commenced.

EG
W/C
Training
Show in Cell

16th Feb
22nd Feb
16th Feb

23rd Feb
25th Feb
23rd Feb

View 4 Replies View Related

Underline Text With Different Color

Aug 24, 2009

Is it possible to underline text with differenet color? Text is let say std. black, and need red underline. (I can change color of cell down but I would like underline line in right test test. underline.xls

View 3 Replies View Related

Calculating Distances Between Back-to-back Locations

Aug 11, 2012

I have a layout something like the following:

A1
A2
A3

[Code]....

Where each (i.e., A1) represents a location. I have tried to use a coordinate system but this will not work for the back-to-back locations. (Assuming each location is 2 feet wide, For example A1 to C1 is 4 feet apart, not 2 feet (as Euclidean or rectilinear would calculate it as).

Would there be a way to incorporate an if statement for those locations that are back-to-back? As a rectilinear distance calculation would work as long as the locations are not part of the same "block".

Ultimately I am looking to have a matrix which contains all the distances between each location:

A1
A2
A3
B1

[Code].....

View 4 Replies View Related

Delete All Text Which Is Not 'bold' In Cells With 'mingled Bold' Text

Jan 23, 2010

I want to have a function or macro that if cells have mingled bold text, that only the bold text shall remain in the cells, and all the rest of the text must be deleted.

View 4 Replies View Related

Highlite Or Underline Active Cell Row

May 28, 2009

Is there any way in excel to allow for whenever clicking on an active cell to make an underline or highlite the entire row that that cell is in?

View 2 Replies View Related

COUNTIF Function To Autom. Underline

Aug 18, 2009

look at the attached file. How can I have the text values in Column A automatically be underlined if the concerning value in Column C drops below the value "1"? Note that Column C wont give you number values in this sample book as it refers to another file on my hd.

View 4 Replies View Related

Format (Underline) Text With A Formula?

May 19, 2013

I need to underline text which is populated from a formula. How to format numbers, dollars and dates within a formula, but how to underline text.

Desired Result: The employee's who sold more than 100 cars this month are: Alex, Mike and Tim. Please congratulate them on their performance!

Formula being used ="The employee's who sold more than 100 cars this month are: "&cell reference&"Please congratulate them on their performance!"

Current result: The employee's who sold more than 100 cars this month are: Alex Mike Tim Please congratulate them on their performance!

Attempts: I wish underlining text were an option within Format Cells/Custom so I could just use the formula =text(cell reference, "underline"). However, I don't see that as an option in the 2007 or 2010 versions. Is there a way to add "underline text" as my own custom format?

I also tried using "Conditional Formatting" (both "Format cells only that contain" and "Use a formula to determine which cells to format)." I can't quite get it because I don't know how to list names for the former conditional formatting. Vlookup is the only way I know how to refer to a list for the formula based conditional formatting, but this would stop after the first name on the list is found and ignore the rest of them.

View 9 Replies View Related

Underline Word In Concatenate Function?

Apr 22, 2014

each cell contains one word say hello in a1 and Henry in b1. Is it possible to underline Henry after =concatenate(a1,b1) ?

View 4 Replies View Related

TextBox Develops Underline After 1st Character

Apr 13, 2008

When I enter some text into a TextBox, the first character is fine, but after the second character has been entered, the font seems to develop an underline. I've created a Word document with screenprints but have been unable to make it small enough to upload here, despite trying for the past couple of hours! You can therefore see the document here ... http://www.keepandshare.com/doc/view.php?id=508384&da=y

View 8 Replies View Related

Excel 2010 :: Pivot Table - Manual Edits Don't Revert On Refresh

Oct 22, 2012

If a user changes some data in a pivot table and then refreshes the table, the changed values are supposed to revert to the source data, right? This does not happen in my pivot table.

Any changes made in the underlying data get transferred to the pivot table refresh, as expected. But if I change some values in the pivot table, followed by a refresh, then the cells that I changed remain the same unless I happened to modify the corresponding values in the underlying source data too. In other words, the refresh operation does not touch the pivot table except specifically where an update is driven by a change in the underlying data.

This behavior is different from what i remember from, say, excel 97 / 2000.

View 3 Replies View Related

Table Names Revert To Cell Names When File Is Reopened

Jan 4, 2013

I have a worksheet with many tables that I use in formulas.

I like tables for a couple reasons, one being the ability to insert/delete rows without affecting the rest of that worksheet row.

Also, automatic copy of formulas/formatting is great.

But, what I really like about tables is the ability to use the naming conventions in formulas.

Problem is when I save this worksheet, after I close it and open it back up, all table references in my formulas have been converted to cell references.

Example:

Code:

=IF((SUMIF('Quote 1'!$M$28:$M$43,">"&'Quote 1'!$J$57:$J$60)*'Quote 1'!$G$57:$G$60)+(COUNTIF('Quote 1'!$M$28:$M$43,""&'Quote 1'!$J$57:$J$60)*'Quote 1'!$G$57:$G$60)+(COUNTIF('Quote 1'!$M$28:$M$43,""&tblOSSRV[Min Order Cost])*tblOSSRV[Cost / Part])+(COUNTIF(tblFam[[#Data],[Qty by Factor2]],""&tblOSSRV[Min Parts Per Line])*tblOSSRV[Cost / Part])+(COUNTIF(tblFam[[#Data],[Qty by Factor2]],"

View 4 Replies View Related

NORMAL DISTRIBUTION

Oct 24, 2005

I know EXCEL has functions for both the NORMAL DISTRIBUTION and the
cumulative value thereof...

but is it possible to graph this data..

(I imagine if I sort the data and then calculate the ***. distributions into
a column...then chart it, it should work; BUT IS THERE ANOTHER WAY?)

View 13 Replies View Related

Normal Print Preview

Apr 28, 2013

I keep reading that this "Application.Dialogs(xlDialogPrint).Show" brings up the same dialog as File-> Print or Cntrl+P but it does not.

Instead I get this wrong.jpg

When I actually need this correct.jpg

How to get the second one?

View 7 Replies View Related

Normal Distribution Graph

Nov 16, 2006

Say I measure the height of 1000 people and I have those in a column in excel. It should be a normal distribution with mean x and standard deviation y. How do I actually graph it so I can see the normal distrubution curve that looks something like this:
[url]

I tried making a scatter graph but it graphs them point by point. I want the height to be on the x axis and something like frequency on the y axis.

View 5 Replies View Related

Currency To Normal Number

May 30, 2007

I have a value say 11.50 what i need is for this to be turn in to 1150 no point.
When i try on excel i get it to 115

View 4 Replies View Related

Is Random Normal Distribution Possible

Jul 18, 2007

i have some number that i want to put in a normal distribution

so.. i have age ( 1, 2, 3, 4, 5, 6, 7, 8, 9, 10) and have the number of times that the kid wake in the night ( 10, 12, 9,11,8,9,7,9,11) and want to do the normal distribution grafic with that .

View 3 Replies View Related

Normal Distribution Chart For Set Of Data

Feb 22, 2014

How to crate a chart for normal distribution for a set of datas. say marks of students/ number of students in a class

View 1 Replies View Related

Probability Density (normal Distribution)

May 11, 2014

I'm trying to make a bell curve (normal gauss distribution). I have some problems regarding the probability density curve, since its values are so low. If you look column N in the attached file - I used the NORMDIST command. Values should be somewhere between 0,2 and 0,4 - but they're about 100x lower.

View 2 Replies View Related

Only Few Cells Normal - Rest Greyed Out

Mar 16, 2013

I sometimes come across spreadsheets that have only a few white, "normal" looking cells and the rest are grey with no borders.

Usually there is a thick blue line around the "normal" cells and I can make more cells look "normal" by dragging the blue border line.

What is this? And, how do I set it up in a spreadsheet if I need to?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved