Default column formats
Hello, How can I change the default column formats for all opened and new
books. EG: Format of column's 1, and 3 are general, and column's 2,5,6 are
can't to that.
but sounds like you are using the format a lot.
set a blank wb to this format. when you need a new wb with
this format, call this one. when you save it, do file save
as and give it a different name. this way you will always
have a wb set to this format.
>Hello, How can I change the default column formats for
all opened and new
>books. EG: Fo...What does it mean when there are all xxxxxx's in the cell.
I need this answer very soon
do you mean ########?
if so, it means your column isn't wide enough to display the data.
> I need this answer very soon
If you do mean ###### then you need to double click between the column
headings to make the cell wide enough to see the content.
MCT, MIITT, Mos Master Instructor
> I need this answer very soon
Saved from a previous post.
It could mean a few things.
1. The columnwidth is too narrow to show the number.
Widen ...Problem with cell formatting and underlining
I'm using Excel 2007, SP1. I'm having a problem with cell formatting.
Here's the situation:
Normally, if data are entered into a cell, they will appear past the edge of
the cell as long as there's nothing in that cell. And that's what I want.
However, if I choose to mark the contents of the cell as Underlined,
everything goes wrong. The cell will clip all text that falls outside the
border of the cell.
Does anyone have any idea how to either fix this or get around it? I'd
hoped that SP1 would have solved the problem, but no.
I have a spreadsheet that has data I want to extract that resides in
every 4th cell down. So for example:
Row 1 - Name
Row 2 - Address
Row 3 - City State Ziop
Row 4 - Phone Number
It is row 4 I want to extract and I am looking for a way to extract
ONLY the data in each 4th row into a spreadsheet that will have all
phone numbers listed.
In A1 of Sheet2
Gord Dibben MS Excel MVP
On Mon, 26 Apr 2010 10:35:10 -0700 (PDT), Kip <email@example.com> wrote:
>I have a spreadsheet that has data I want to...Display size of dataset in memory
I'm very much a VBA novice so please forgive me if this is a silly
I have defined 2 class objects into which various information is loaded
as my code runs. I need to be able to display the size of the dataset
currently held in the memory when the code has finished running but
have no idea how to do this...
Any help would be greatly appreciated!
...copying value of cell to another sheet
I'm hoping someone can help me...
I have a worksheet called ENTRY
When you enter quantities it adds up with a total sum at
I created a macro to clear the quantity column so I can
start over again.
But I want to record the total sum on another worksheet.
When i do it now it just replaces the info in the same
cell - I want it to enter the next value into the next
Any help appreciated.
It would also be nice to have the same macro do both -
copy the value, then clear the contents...
Here is the macro
' ClearContents Macro
' Ma...Auto Formatting Cells and Dates
I noticed that if you type in something like 3/16 excel will assume you meant
March 16th and change the cell to a date. I know you can change the format
to text before you type the date in. Can you turn it off completely? Are
there any options you can change concerning this feature (like the date
format it changes to). Can you create your own autoformats concerning
numbers other than dates?
preformat the cell as Text
start your data entry with an apostrophe: '3/16
> I noticed that if you type in something like 3/16 excel will assume you meant
> Ma...manually selected Excel cell formatting
I've installed Excel 2007 recently. I notice when I manually select
non-contiguous cells using the ctrl key that the selected cells are not
highlighted like they were in Excel 97. At first I thought I was losing the
selection altogether but I noticed that the current cell had a thin outline
instead of the heavier normal outline. It was then I saw that the selected
cells were actually very faintly shaded. I checked that the cells were really
selected by migrating through them with the Enter or Tab key. Is there any
way to make the selected calls more visible? Or is something w...Last cell in row range with a result
I need to see if anyone can tell me if it's possible to find the last
cell in a range that has a result and not just a formulas. We have this
file that has a row of formulas as each cell it a different day of the
month. In another file I need to pull the current cell and at this time
I have to change the cell reference. Please let me know, thanks
if you have a row of data , say row 3, with no included blanks, then the last
value in that row is:
Gary''s Student - gsnu200713
Gary''s Student wrote:
> if you have a row of data , say ...Problem with Tools displays
Recently I've started having a problem in Outlook XP
(Outlook 2002), under Windows 2000 Professional, where all
the windows that open up under the Tools section (e.g.
Tools-> Options) have fonts that are too large and the
contents of the windows are cut off. I saw a support item
that mentioned a corrupted Tahoma font but replacing the
font in WINNT\Fonts has not helped. Any ideas what else I
>Recently I've started having a problem in Outlook XP
>(Outlook 2002), under Windows 2000 Professional, where
>the win...Copying spinners for each cell in Excel 2003?
I have an inventory tracking sheet that keeps track of my inventory.
I've added in a spinner control to increase/decrease a value in a
certain cell. In my worksheet, the value is located in column E, and
the spinner control is in column F. I have about 200 spinners to add,
and need to fill down the links to it's adjacent cell. I found
something related to checkboxes, but how do I adapt it for the spinner
control? The first value is in E3, and the first spinner is in F3.
Create 200 spiners in F3:F203 and link to E3:E203
Dim myRng As Range
Dim Spnr...Format in if formula
I want to use the "if" function and change the format
(color) of the cell if the outcome is true or false.
...copying a cell to another cell automatically
I'm trying to set up my worksheet so that if the value in column E is
changed to 100%, the value in column A of that row automatically changes to
100, regardless of its original value. At the same time, I don't want to
lock down column A - the user can enter any value in here when E is not
100%. How do I go about doing this? Do I need to write a macro?
You'll have to do this as a little macro. Go into the VB editor and add the
following into the relevant Sheet.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 5 And Target = 100...V-lookup and format
I am making a dashboard for work and am using lots of v-lookups t
access a spreadsheet with lots of departmental information. I have th
v-lookups for the data all figured out, my question is this: Is there a
easy way to bring the format with the data. for instance some of th
numbers are just numbers, others are percentages, thus they come to th
new cell as .23 instead of 23%. Below is an example of the v-lookup i a
=VLOOKUP($B22,'[People Hub.xls]people hub'!$E$9:$R$5000,'[Peopl
I don't want to preset the cells format in the da...Setting Conditional Formatting in 2007 saved as 97-2003
I am working in XL 2007, but my workbooks save as the lower version.
I have two columns of cells that I would like to apply a Conditional
Format to. I figured out the Rules Manager. But I'm not sure about
applying my conditions.
I have three possible values in column A; depending on the value, I
want to set the font color in cols A and B. Would it be better to set
three separate conditions across the cells? Or use some type of IF
formula in one condition?
Use three separate conditions
Bernard V Liengme
Microsoft Excel MVP
remove cap...Date Format #2
Frequently i am downloading some datas from our ERP,in which the date'
are downloaded as in this style.
i am not sure this in what format.But when i use the formulae
=days360(a1,b1,true) to find the difference between 2 dates,excel i
giving error msg as #VALUE!
pls help me to sort out this issue.
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
check that the cell is not in text format,
try 28/11/03 to test if there is any change....Re: Excel 2007 column chart fill question
I would like to fill my column chart with cross hatch, vertical hatch,
horizontal hatch, etc. instead of colours. The only method I've found
currently is to fill with different picture types that have the
different type of hatches. I'm certain there must be another method.
Does anyone know how? Thank you.
Pattern fills have been deprecated, MS term for removed, in 2007.
Picture fill is the only way.
Anvah Gareson wrote:
> I would like to fill my column chart with cross hatch, vertical hatch,
> horizontal hatch, etc. instead of colours. ...Resetting cells to zero value.
I have lots of cells with numbers. Can I place a button that will reset all
cells to zero?
Right now, when I want to start over, I go to each cell and change it to
zero. I have 250 cells.
Thank you if you can help with this.
Select the 250 cells you want to reset to 0.
Hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
Selection.name = "ClearThemAll"
and hit enter
Now back to excel select any cell.
Start recording a macro.
(to fill all the selected cells with 0)
stop recording the macro (or s...How to format a date to a different format
I need help in converting a date "20050205" where the first 4 numbers are the
year, the 2nd two numbers are the month, and the last two would represent the
day of the month. I have tried several things to format these and looked in
Help but I am not asking the right question. I want to be able to have the
data read 02/05/2005 or something close such as 2/5/05. The date format it
is currently would be fine if that was the only report, but I have several
other downloads that I work with and those dates are in the format I am
requesting. Also the original format is hard to re...eliminate duplicate in a column
How to eliminate duplicate in a column?
Quick fix would be to apply data>advanced filter, unique entries only and
copy to another location
(No private emails please)
"jaya" <firstname.lastname@example.org> wrote in message
> How to eliminate duplicate in a column?
> Quick fix would be to apply data>advanced filter, unique entries only and
> copy to another location
Try that with the
The result will be same as the initial column. However, it does not...conditional formatting
I have a subform based on a query. The query includes a text field for
"details" and a memo field for "Notes" in which contains additional
information which is beyond the capacity of the details field. I want
to apply conditional formatting (a change of colour) to the details
field on the subform to indicate when there is additional information
in the notes field.
I have based the conditional formatting on an expression which tests
whether the Notes field contains a null value. The notes field in
placed on the subform, as I understand that it needs to be there in
order to ...Plotting with a formula in a cell
I need help with this, I am sure it is a simple answer,
but I cannot figure it out. I have a workbook with 2
worksheets in it. The first worksheet has all the inputs
from my data in it, and the second worksheet has the
charts in it. I have pasted the links into the second
worksheet and all is fine with that, but when the value is
zero, it plots it as a zero. I would like to just have it
as a gap when the value is zero. I have gone into the
options menu and clicked on the one that reads "NOT
PLOTTED,(LEAVE GAPS)", but it does not seem to fix it.
What I found is that be...Reprint AP check format on plain paper
Provide the ability to print a "copy" of a previously printed check w/
stub (with "void" in the signature section)
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
I have excel 2007 (sorry for the previous post)
I have a table like this
Start Date Duration Staff Staff 2
JOB 1 5/1/2009 29 Bob Dan
JOB 2 5/1/2009 60 Jeff Denise
JOB 3 5/15/2009 61 Ben Dan
JOB 4 5/15/2009 61 Jeff Paul
I would like to be able to have different colors for each person.
Only want each job listed once on the left.
Are you trying to create a gantt chart or do you just want to color each row
a different color.
Check out the topic Gantt Charts at Jon's site:
If you only want to color ...Pick up Formatting/Apply formatting
My Publisher 2000 had a wonderful feature that I used all the time. I could right click on a text frame and "Pick up formatting" then I could click on another text frame and "Apply formatting
I purchased Publisher 2002/XP, and I can't find this wonderful feature anywhere. I sure can't easily right click to get it, but could it hidden somewhere and I just can't find it?
A small child turns to Ed, and exclaims: "Look! Look! A post from Judy
> My Publisher 2000 had a wonderful feature that I used all the tim...