how do i delete cells or duplicate cells in a table ?
I went to make a table with 8 colums and 3 rows, which turned out fine..but
now i need to make 3 more rows added on but half the size long with only 2
so i figure i can just duplicate or copy from my table 3 of these rows and
shirk it and delete 1 cell...but trying to get help on how to add or remove
cells seems the hard part
...CELL FORMATTING #9
WHY IS MY CELL FORMAT AT WORK DISPLAYED PROPERLY
-1,500.OO IS DISPLAYED AS (1,500.00)
AND WHEN i DO IT AT HOME Ii CANNOT GET
THE CLOSEST I GOT IS -1,500.00
is there a diffence between the formatting cell options
between Excel's programs..
Excel takes it from your Windows Regional options.
Start > Settings > Control Panel > Regional options
Change the negative number format
You'll find that you now have () options.
Norman Harker MVP (Excel)
Excel and Word Function Lists (Classific...Hyperlinks not moving with cells when data is sorted
I have a spreadsheet where I have included hyperlinks. When I sort the data
or add new rows, the hyperlinks are NOT moving to the new destination of the
cell. Big problem! How do I get Excel to keep the hyperlink moving with the
cell, wherever it may go?
Using Excel 2003.
...change date in a sql statement from a cell
I am using Excel 2007 I have a pivot table that gets refresh everyday. The
data from the pivot table is based on a sql statement, which the data is
connected to a AS/400 table. Here is my problem every morning I go in the
connection properties and change the SQLstatement (date) in the command
text. I don't want my user to do this. What other option can I do? I was
thinking change the date in a cell (A1) and somehow the SQL statement picks
up the new date or maybe some sort of parameter, but I am clueless in how to
do this. Any tips or website to visit I will a...Unique Entries/Cell Back Color
I have two columns with Grant Numbers in each column
coming from two different databases downloaded to an excel
spreadsheet. I will need to first Match the Grant numbers
and highlight the whole row if something is unique meaning
there are duplicates,triplicates, one exist in one column
but not in the other. I need your help!
Thanks but for some reason this is not working. Should I
put my formula in column C? I have two columns with data
in cells A1-A6266 and data in column B1-B5016. I can see
the formula it's not working in column C with the results.
is there a command that ...Return the name of cell to sheet name
How do I return the cell name to the sheet name. When I start a ne
sheet I write a name in a cell and I want it to automatically renam
the sheet to that cell name
AndreaOlsson's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1651
View this thread: http://www.excelforum.com/showthread.php?threadid=31367
introduce this in <thisworkbook> event
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target
ActiveSheet.Name =...picture in a footer
Does anyone know how to display a picture in a footer? I followed the
workaround to get a picture in a row to repeat at top but can't figure out
how to get a "logo" to repeat at the bottom or in a footer. Anyone??? Thanks
in advance. I'm using excel 2000
This feature was introduced in Excel 2002.
Place the logo where you want it at bottom of a blank sheet.
Print out a bunch of copies then use these in your printer tray.
Gord Dibben Excel MVP
On Tue, 16 Nov 2004 13:39:01 -0800, Suzgreive
>Does anyone know ...Inserting picture as a background
I inserted a picture as my background from my hard drive. Multiple images
appeared in the document. I know that if you are working with a webpage it
tiles so that the image appears on each page. But I am creating a brochure
and only want 1 image. Has anyone else experienced this and do you have a
When you use the Format >> background you will get tiling. Best to put an image
on the Master Page and stretch it to fit.
"Kimberley" <Kimberley@discussions.microsoft.com> wrote in message
news:F2123E93-DDEF-4...Chart Title or Text Box Linked to cell & sheet
I need to create charts from data collected via a com port. As i
stands, the data is written to sheet 1. Chart 1 is ready to plot dat
as it is written. Once the data is complete, I copy sheet 1 and char
1. This results in sheet 1(2) and Chart 1(2). All references to shee
1 on the newly created chart 1(2) automatically changes to refer t
sheet 1(2). This applies to data ranges, Chart Title, Axis names.
When creating text boxes refering to sheet1!$A$1, the reference doe
not automacially change to sheet 1(2)!$A$1. Can this be done?
If not, can I create multiple chart titles?
Any help o...Free Cell card game
Currently this card game appears at the top left of my 21 inch screen.
I wish to have it in the centre touching the bottom of the screen each time
it appears. How do I achieve this.
Thank you for your interest.
And your Microsoft Word question is?
"Ernie from Dunedin NZ" <Ernie from Dunedin NZ@discussions.microsoft.com>
wrote in message news:E05D1650-D1CA-4E1C-96FB-CF8EC0D17277@microsoft.com...
: Currently this card game appears at the top left of my 21 inch screen.
: I wish to have it in the centre touching the bottom of the screen each
: it appe...Export data from the same cell from multiple spreadsheets into a n
I am working with weekly timeshets in Excel and I am using the same form
every week, but save it as a file named "Timesheet 20100122" for a week
ending on Fri, Jan 22, 2010 (Our accounting week period). Therefore the daily
hours appear every week in the same cell. I would need to export these hours
to another - summarizing - spreadsheet (For example and invoice spreadsheet)
somehow automatically. Any help would be welcomed.
Thanks for your help,
Regards Ron de Bruin
when I try to sort a spreadsheet by certain columns, why does it mix
"mix everything up" is not very informative. More information, please: What
columns are in your data range? By what columns are you sorting? What is the
result you get?
"Help with cell function" <Helpwithcellfunction@discussions.microsoft.com>
wrote in message news:7886A10E-903D-40C9-8D2A-279090F2D644@microsoft.com...
> when I try to sort a spreadsheet by certain columns, why does it mix
> everything up?
Be careful when you highlight the data that y...Split text cell into seperate colums without splitting up a word
I have text cells with sentences ranging from 0 to 160 characters long. I
want to break these into 40 character chunks (in separate cells), but don't
want to split any word in half. ie, if the 40 char mark is in the middle of
the work, I want to go backwards, find where the word starts and split from
that point. It's exactly like a wrap text -- but I want to split those lines
up into separate cells.
If your sentence were in A1, use these 4 formulas:
=LEF...Hyperlink problem to cell in same workbook
I have a hyperlink created by a VB program that should link to a cell
on a different worksheet within the same book.
The hyperlink code currently is as follows:
MultipleAliases is a separate worksheet and I want the link to jump to
row 4 cell 2 on this sheet.
I realise that normally you need a spreadsheet identifier as part of
the worksheet definition, thus the "MultipleAliases" would be
"[FILE1.XLS]MultipleAliases" if this was saved as FILE1.XLS.
If I do save this file wi..."Address" of current cell
Is there a function that will return the "address" of the active cell?
In other words, if I'm on cell G9, it there a function I can use that will
Doug Mc wrote:
> Is there a function that will return the "address" of the active
> In other words, if I'm on cell G9, it there a function I can use that
> will return 'G9?'
Or slightly less typing
"Frank Kabel" <frank.kabel@fr...Rename Cell Name
hey all, i have change the cell anem from A1 to StartCell. Bu, how can i
rename it back to A1 or change it to another name?
Thanks in advance
go into insert / name / define - you can delete the name there and create
another if you wish.
"Dragon" <Dragon@discussions.microsoft.com> wrote in message
> hey all, i have change the cell anem from A1 to StartCell. Bu, how can i
> rename it back to A1 or change it to another name?
> Thanks in advance
> Drago...Need a ZERO as the first character in a cell
How do you make the first number in a string of numbers a zero and keep it
Depends on if you want a *true* number, or a text number.
For Text, precede the entry with an apostrophe ( ' ),
OR, pre-format the cell as text.
For true numbers, custom format the cell with the number of digits you're
Please keep all correspondence within the Group, so all may benefit!
"Mr_Jim" <MrJim@discussions.microsoft.com> wrote in message
news...need some help with: formatting of x2 dates in 1 cell
Hi and thanks to anyone who reads this.
I have a worksheet which contains two columns of dates.
In a second worksheet i have a column which adds the two dates together
as TEXT and ommits dates which are blank which works perfectly,
I would like to know how i could format each of the 2 dates in the 1
cell to have different font colors?
Here is my existing cell formula:
I have a feeling its not...A2 cell reference increment
I want to reference a cell using some math:
$B(1+1) which I would hope equals $B2 and the cell would then contai
a reference to $B2.
How does one perform math funtions to the row part of a reference?
I what to be able to reference a cell that contains a cell reference
So Cell A1 would contain the text B12
cell A2 would reference to cell A1 and show the contents of B12.
and in cell A3, I want to show the contents of B13... but I want t
take the contents of cell A1 and increment it from B12 to B13...
How do I do that? I tried simple math like $B(1+1) which does no
T...cell format update problem #2
c1, c2 is formatted as text.
and a1,a2,b1, b2 are formatted as general.
a1=1,a2=2, b1=1, b2 =2
and I entered c1 =a1+b1,
c1 shows =a1+a2 as it is, not 3.
I drag the corner of c1 and copy c1 to c2,
c2 is a2+b2,
So I have to F2 and enter all the cells, c1, c2.
Is there a way other than "F2" and "Enter"?
Consider formating c1 and c2 as general.
> c1, c2 is formatted as text.
> and a1,a2,b1, b2 are formatted as general.
> a1=1,a2=2, b1=1, b2 =2
> and I entered c1 =a1+b1,
> c1 shows...Extracting Data in Cells in order -- (or) eliminating empty cell space in a column
I have this problem that I bet is easy to solve, but i am lost. I am an
expert at the slow way to do things, but maybe there is a better way.
The only way I can describe the problem is by means of an example.
Lets say I have a column of numbers:
>_A_|_B_| etc >>
and then i write a little function in the adjoing cell, B1:
From there I fill down column B to B9.
OK, pretty simple so far, right? What I am looking for is instances
where I find a '3' in co...Remove extra characters from a cell
This may be something simple, but does any one now how to
remove leading characters from a cell that was imported
from another system. The first 8 characters are zeros and
don't belong in my spreadsheet. Thanks in advance.
you could enter the following in a helper columne
and copy this down
> This may be something simple, but does any one now how to
> remove leading characters from a cell that was imported
> from another system. The first 8 characters are zeros and
> don't belong in my spreadshe...What is Excel hotkey for cell lock, C1 to $c$1
I recall a hotkey that can lock all the cell references in a formula.
ex. A1+B1 to $A$1+$B$1
the F4 function key
> I recall a hotkey that can lock all the cell references in a formula.
> ex. A1+B1 to $A$1+$B$1
Select the formula (or a part of a formula) in the formula bar,
and press F4 to cycle between the 4 reference styles.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"BLUTO" <BLUTO@discussions.microsoft.com> wrote in message
news:3B63B604-B495-4B8D-A791-060613174EA6@microsof...Alter a picture
Is it possible to ungroup an imported picture and make changes to it? I have a picture of a maple leaf and I would like to keep just the outline. Using Pub 2003, Windows XP
On 02 May 2004 12:41, "Vanilla" <email@example.com>
>Is it possible to ungroup an imported picture and make changes to it? I
>have a picture of a maple leaf and I would like to keep just the
>outline. Using Pub 2003, Windows XP.
Depends on the picture format. What format is the picture in?
Microsoft Publisher MVP
http://www.mvps.org/...Sort on Cell Colour
Hello, Is there any way to sort depending on the colour
of the cell background? The row will contain the same
colour for all cells...
"Nick" <Nick@nospamhere.com> wrote in message
> Hello, Is there any way to sort depending on the colour
> of the cell background? The row will contain the same
> colour for all cells...
> Regards, Nick.
It's all described here: