General
in [Excel]
|
Excel Text Formula I'm combining text from four different cells into one cell, which works well. However, I would like the information from one of the four cells to be Bold Face while the others remain normal. Is there a way to write a formula that will allow this? ... 4 Jun 2010 10:21
Excel calculation problem I think something in Excel 2007 is trying to be too clever by half (or is it a bug?). Col A Formula Result Expected 2.25 =a$1 2.25 2.25 2.25 =a$1 + a2 4.50 4.50 3.50 =SUM... 4 Jun 2010 09:13
import color scheme from another excel (2007) hi, in former versions of excel, import color scheme from another excel: on the menu bar>tools>options>color tab in the "copy color from" box, click the down arrow and select the workbook which contains the color schemes but, for excel 2007? thanx ... 4 Jun 2010 09:13
Automatic design for Excel hi i am using a 3rd party system, that is exporting excel reports. i need to send these reports to customers, so they neeed to be designed in the same way. is there a way to have this exported excel file with a one click of a button designed with a pre defined template? i mean instead of openning a new template... 4 Jun 2010 07:02
Macro Message Bar I have set macros to be automatically disabled with a notification but the message bar doesn't always come up. Does anyone know why this may happen and how I can fix it please? ... 4 Jun 2010 20:18
List values based on different values selected State : Type1 : Type2 : Type3 : Alaska Arizona Type1 Alaska1 Type1 Arizona1 Type2 Alaska2 Type2 Arizona2 Type3 Alaska3 Type3 Arizona3 Alaska1 Alaska2 Alaska3 Arizona1 Arizona2 Arizona3 1.1 2.1 3.1 11.1 12.1 13.1 1.2 2.2 3.2 11.2 12.2 13.2 1.3 2.3 3.3 11.3 12.3 13.3 1.4 2.4 3.4 11.4 12.4 1.5... 4 Jun 2010 10:21
Using SUMIFs on a changing Pivot Table - Help! Hello all I have a pivot table with revenue as the data, dates as the row fields and the column fields as countries. I am using a SUMIF formula to add together the revenue for numerous dates depending on what dates the user specifies. The problem however is that the column fields in the pivot change if a new... 4 Jun 2010 12:34
DROP DOWN LIST Hi I would like to create a drop down list if names that opens when the spreadsheet opens so people can pick theyre own individual sheets. How can this be done? Thanks ... 4 Jun 2010 04:52
DROP DOWN LIST Dave... try to open this link...so many information about creating drop down list http://www.contextures.com/xlDataVal01.html reza "Dave" wrote: Hi I would like to create a drop down list if names that opens when the spreadsheet opens so people can pick theyre own individual sheets. How... 4 Jun 2010 19:13 |