Cell Wrapping Help
I changed the default height of the cells on my spreadsheet to 17.25. I
have a cell "Comments" set to wrap text; however, it does not. If I
double-click on the far left column (e.g., the bottom of the cell in
question) it automatically adjusts.
I need this "Comments" cell to grow and enlarge as if the cell was at a
default height of 12.75.
Any ideas without having to double click on each cell? I have over 5,000
Thanks for the help!!
Nevermind, figured it out.
...=CELL("filename") returns #VALUE!
When I use =CELL("filename") in Turkish regional style, it gives #VALUE!
error but if I change the settings to USA, it works!
Why? And how I can solve this ?
PS: I use an english office 2007 and I use the formulas in English, no
problem with any of them. But I got error with this.
Thanks & Regards,
Presumably you need to use the Turkish equivalent of "filename" in that
formula. I have no idea what that might be, but if you have Turkish help,
try looking up 'CELL function' in help, the info_type is listed there,
hopefully it ...MATCH, VLOOKUP? How to get T/F Result?
In one sheet of a multi-sheet workbook, I've got a column of customer
numbers. In a separate sheet, I've got a column of customer numbers which
represents a subset of the whole customer list.
I need to be able to add an alpha code (single letter) in a separate column
on the first sheet if the customer number on that row is contained in the
subset list on the second sheet.
Logically, Excel needs to look at the customer nimber on sheet 1 and try to
find it on sheet 2. If it does find it, place an "A" in the cell, if it does
not find it, leave the cell blank.
I've e...2003 slow to show updates/changes
I as lots of people am used to 5.5. When changes were made on this
server details and settings were changed instantly. How come when i
make changes on my new 2003 server the changes do not take effect for
the properties of a clients mailbox for approxiamatly 30 minutes. I
changed the mailbox limit.
Why does it take so long? Surely it does not have to replicate to all
the other 2003 servers. I changed the settings on the server for the
user whose mailbox was also on the same server.
Without knowning much about your setup, it's hard to tell. But, changes do
have to replicate..."Show in folder" never works
Several applications on my system have a "Show in folder" option. None
of them work, though they did in the past. The applications include
most browsers, for example. It is unlikely that they are all ding
I presume they are just launching explore.exe with suitable
parameters. There's nothing wrong with explore.exe on my system as far
as I can tell (other than this problem).
"Swifty" <firstname.lastname@example.org> wrote in message
news:f...Outllok Today doesn't show message count
The last time Outlook hosed over my PST file, even though I've created a
completely new one, my "Outlook Today" page won't show the number of
messages in any folder that include on the page. I'm using Outlook 2002
(10.4712.4219) SP-2. Any ideas?
Brian Tillman Internet: Brian.Tillman at smiths-aerospace dot com
Smiths Aerospace Addresses modified to prevent SPAM.
3290 Patterson Ave. SE, MS 1B3 Replace "at" with "@", "dot" with "."
Grand Rapids, MI 49512-1991
This opinion doesn't represent that of my company
...Macro to coppy cells to certain rows depending on value in cell
I want his macro to after it have inserted the colmns and added the formula to
1. copy range A1 to E1 to every row where the word "Header" is in colmn F.
2. Then copy paste the whole sheet as values.
3. Then the range now standing left of "header" must be copied to the empy
cells beneath each heading.
a b c d e
1)12/12/2005 F001 SAO3 1 CCE Header
...define a cell with the value of anothe cell
I'm very new to excel and i think i just don't understand a basic function
but i couldn't find it under the help menu.
how can you define a cell using a letter and then a value of another cell?
here is an example
my guess was =D(W15) which i would like to equal 10, but i get a name error
Todd Duncombe <Todd Duncombe@discussions.microsoft.com> wrote:
> I'm very new to excel and i think i just don't understand a basic
> function but i couldn't find it under the help me...Merge/consolidate text cells based on unique keys ?
I hope someone can help me out.
I have an Excel worksheet with 2 columns: 'Client #' and 'Invoice #'.
Every time the accounting dept. generates an invoice, a new row is
added in this worksheet.
Obviously this is chronological not per Client #.
But for the sake of simplicity, let's assume the worksheet is already
sorted by Client #, like so:
Client # Invoice #
My goal is to achieve...how to set up a simple variable in Excel, but cell location independent
Can you please show me how to set up a simple variable in Excel, but this
variable must be cell location independent. Because this worksheet will be
sorted and cell location re-arranged and moved. That mean for example,
In one worksheet, I set variable numb = 5
other cell at different location value display will have function such as
numb*2 = 5*2 = 10
Then, other time, I set this same variable numb = 12
then, the call value will display
numb*2 = 12*2 = 24
You might try a named formula.
From the Menu Bar,
<Insert> <Name> <Define>
In the "Names In Workboo...Calculated Fields showing error results
I am trying to get a calculated field to work within a pivot table. The two
fields in the pivot table which I'm referencing are sales and Profit dollars.
I want the calculated field to show gross profit dollars (percent to total
sales represented by profit), but without any error values (!value, div/0,
etc.) where there are no sales for a particular line (i.e. customer) in the
timeframe I'm analyzing. The formulae I've tried are:
=if(isnumber(Profit/Sales),(Profit/Sal...not showing zeros on chart
here is the scenario
x-axis months 1-12 corresponding to jan-dec
how do you prohibit the series from taking a dive to zero for the
months that have no value assigned yet
thanks for all replies
tools options chart
<plot empty cells as> choose your requirement.
<GeneralNuisance@Rme.net> wrote in message
> here is the scenario
> x-axis months 1-12 corresponding to jan-dec
> y-axis dollars
> how do you prohibit the series from taking a dive to zero for the
> mont...Converting custom cell properties to text
I have a column of cells with telephone numbers in it and I wish to convert
- or copy and paste these cells - into text format.
For example, I have a telephone number as 083270000 and the cell properties
(Format > Cells > Category) is listed as "Custom" and the "Type" is listed as
When I conduct a copy and paste, I lose the preceding zero before the eight.
But I need this to remain and I need all the cells in "Text" format!
Any ideas on how to do this?
Format the column as text-go into Format>cells>cu...Delete Table row with first cell not empty
I need a macro to do the following:
I have a table like this, starting in row 6.
] ] A B C D E
6] 1 N N N
7] 2 N N N N
8] 3 N N N N
Rows 11 to 100 are empty.
I want to select area A1:E100 and delete all content from table rows A9:E9
and A10:E10, because these table rows have empty cells from columns B through
to E. The rows are marked by an ID number as in numbers 1 to 5 above. When
cells in columns B to E are found to be empty, the content of the table row,
including the row ID, must be deleted. Note, this is not deleting t...Dates...not showing as dates
Whenever I use a series of date ranges in a chart the display on the axis
becomes a series of numbers (IE 1,2,3,4.....) rather than the
Very frustrating...not sure why.
Two possible reasons.
1. Excel isn't using that range of data for the X values. You need to
select the entire range when you start the chart wizard, or add what's
needed in step 2 of the wizard, or using Source Data from the Chart
menu, using the Series tab to select the category range.
2. If it's an XY Scatter chart, the dates look like num...Problem displaying Cell Shading color on Sony VAIO
When I open Excel documents that have Cell Shading the
colors are not visible on the LCD screen. When I use the
Print Preview I see the colors.
I'd like to be able to see the colors while I'm editing
on my Laptop. The background colors are visible on my
I have tried several different screen modes with negative
results. I've also download and installed all the latest
service packs from Microsoft.
MS Article found at
OFF: Changes to Fill Color and Fill Pattern Are Not Displa...Show summary task headings on reports
for each group of tasks I need to display summary task headings on my do to
list otherwise the tasks are meaningless but the option is greyed out when I
edit the report. I understand why this is (because there is no assignment to
summary tasks) but I need a way around this - any help gratefully received.
(using v 2007) - I have to print to do lists for a number of people so want
it to be as automated as poss....
A best practice is to include sufficient information in the task field
to allow just this--they need to stand-alone without the associated
summary f...Show top three rows when scrolling
I thought I knew how to do this but it didn't work.
I went to Page setup, Sheet and typed in $1:$3 but it didn't work.
What am I doing wrong?
Thanks in advance.
It sounds like you set the rows to repeat at top when the worksheet is printed.
If you want to always see rows 1:3 on the display, then...
Select A1 (just so it's visible)
Everything above the activecell and to the left of the activecell will be
Doug Mc wrote:
> I thought I knew how to do this but it didn't work.
> I went t...Formating to show square meters ie m2
I would like to be able to format in excel the square meters symbol ,which is
m with a small 2 just above, is this possible please ?
Select your range, press Ctrl + 1, go to the Number tab,=20
press Custom and enter:
To enter the 2 hold down the ALT key and type "0178" (no=20
quotes) on your numeric keypad.
>I would like to be able to format in excel the square=20
meters symbol ,which is=20
>m with a small 2 just above, is this possible please ?
You ...Entering specific data in cells.
I have a column formatted in date form. I want to ensure that when a
date is inputted into that column it can only represent a date which
falls on a Saturday otherwise it will display a sign representing it is
not correct data. Any suggestions please.
Not tonight, dear. I have a modem.
- select the cell. e.g. cell B1
- goto 'Data - Validation' and choose 'Custom'
- enter the following formula
> I have a column formatted in date form. I want to ensure that ...how do I replace formula with value or cell reference with value ?
how do I replace formula with value or cell code with value ?
excuse my terminology.
consider that just a subject title !!
I have 2 questions..
based on that concept
suppose some cells have formulae like
If I copy and paste those cells, I get the formula in another cell.
How do I copy the value, paste the value. Not the formula?
(Note, i know using notepad can.. i'm wondering if excel alone can)
How do I turn
i.e. I want the formula in there. But not the original A4+F3+H7
formula. I want the =4+6+3 formula.
even notepad doesn't help ...Show previous animation button
Can someone please help me with some vba to apply to a button which would
show the previous custom animation shown?
Perhaps this is more difficult than I imagine?
Just to clarify what I am trying to achieve...
I would like to be able to use a button on the PowerPoint stage that, once
clicked, would go back to the previous custom animation - much like the way
the mouse wheel does when viewing the slideshow.
Can someone help please?
> Hi all,
> Can someone plea...Fixed Assets don't show on Balance Sheet
I am trying to setup a balance sheet for a new company. I have several
companies setup already with no issues. When I setup this new company it will
NOT show my fixed assets on the balance sheet even though I have setup this
balance sheet exactly like the previous ones. Any suggestions? I am at a
total loss on this.
Are you using AFA (Advanced Financial Analysis) or FRx for this? If
AFA, makes sure your Fixed Assets accounts have the correct Account
Category assoicated with them.
MCP-GP, MCT, MVP
East Coast Dynamics
blog: www.gp2themax....Problem with Blank cells
I am trying to import Excel File to MS Access using Visual Basic.
The problem I encountered is as follows :
When I import an excel file, if the first row of an excel file contains
an empty cell then thereafter the data in that particular column doesn't
I am using OLEDBJET 4.0 to connect and retrieve the data from Excel
It would be great, if anybody can post their thoughts on it!
vgurusa's Profile: http://www.excelforum.com/member.php?action=getinfo&...colour of protected cells
I would like to set up excel so that if a cell or a range is protected it
will be displayed in a different
Can any one tell me how to do this.
regards from south africa
Use conditional formatting. Select the worksheet range, starting from cell
A1. Then set the "Formula is" format to =CELL("protect",A1) and the format
to a pattern fill.
> Hello all
> I would like to set up excel so that if a cell or a range is protected it
> will be displayed in a different
> Can any one tell me h...