When I am in one cell highlight another
When I am in one cell highlight another. Lets say that if my cursor is in
A1 I want D1 highlighted or with another cursor on it.
Then if I move to A2, D2 should be the one with another cursor or highlighted.
Thank you for your help,
Jose Juan Diaz
hi, Jose Juan !
> When I am in one cell highlight another
> ... if my cursor is in A1... D1 highlighted or with another cursor on it.
> ... if I move to A2, D2 should be the one with another cursor or highlighted.
'put' a cursor on non-active-cell... [I don't think it's possible] :(
to highlight 'D' wh...Cells print so small I cannot read numbers. How do I fix?
I have been working with page break. Now I have the grid on 1 page..but it is
far to small to read. now when I try to spread it back to 2 pages, it just
takes the same tiny microscopic type and spreads it into 2 pages. I am stuck
printing tiny type. How can I get the grid cells back to a size that is
It sound like you have selected Fit to 1 page in File > Page setup > Page >
Scaling. Either select to fit it to 2 pages or select Adjust to 100% size
In Perth, the ancient capital of Scotland
and the crowning place of kings
Repl...Process all cells in a (user) selection
I am using this code to give me cell by cell access to a code defined
Dim aCell As Range
For Each aCell In Sheet4.Range("A4:A34")
' Do Stuff Here
which processes every cell in the A4:A34 Range
How do I do the same thing for a selection drawn by the user before
pressing my 'Process' button ?
On 05 May 2010 11:10:21 GMT, Isis <isissoft@NOSPAMbtinternet.com> wrote:
>I am using this code to give me cell by cell access to a code defined
>Dim aCell As Range
>For Each aCell In S...Copy field data to multiple places
Newbi here.... I have a access 07 file of about 1000 records (rows) and a
field (column) I'll call the "project number". All the records do not have
the project number inserted as of yet. Is there a simple means to insert a
project number in say 50 records at a time, another project number in
another 75 records etc. Copy/Paste will do it but may take months to enter.
Any suggestions appreciated. TIA
On Wed, 27 Feb 2008 15:31:05 -0500, "Meebers" <firstname.lastname@example.org> wrote:
>Newbi here.... I have a access 07 file of about 1000 records (rows) and ...Pivot Tables & changing data
Hi - I have never used pivot tables in Excel before so hopefully what I am
going to ask is possible and not too complicated for me.... :o)
I am working with Excel 2003. I have a pivot table already set up and the
information is pulling data from a row titled "sum of Subscriber". I added
new data in a new column from the main spreadsheet and I would like to pull
the data from there. Its titled "Adj Subscriber".
Is it possible to switch it? If so, how?
Thanks, Anna Marie
> Hi - I have never used pivot tables in Excel before so hopefully what I am
&...how to edit my x-axis data on a line graph
Operating System: Mac OS X 10.5 (Leopard)
my x axis data on my graph is just showing numbers 1 2 3 4 5 6 7 8 9 10 11.... and it is suppose to show the years. I can't figure out how to change these values
...think cell program
is anyone familiar with a program called think cell? Any thoughts?
(powerpoint v 2003). Is this an add-in?
It's very good. You can "try for free" from their website:
Recent interview with one of the founders on Indezine:
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2010? http://www.echosvoice.com/2010.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/3...Data from Access query to Excel
To pull data from an Access 2003 database, I have created
the queries in Access, then import into Excel. The
problem is that all the numbers that are pulled into
Excel are text and need to convert them into numbers to
run formulas on. I have converted a few sheets by hand,
but, some have will over 50,000 rows. Is there a
function to select all number colums (the colums are the
same through out the sheets) and convert?
There are instructions here for converting text to numbers:
You can select all the columns, and only the num...How to delete duplicate data
I am using excel to consolidate monthly room booking data. I have a date
column and time column.
May I know how to to delete those rows which contains duplicate data with
same date stated in the date columnand and same time range in the time column?
Data>filter>advanced filter, unique records only and copy to another
Excel 95 - Excel 2007
Northwest Excel Solutions
(Remove ^^ from email)
"PL" <PL@discussions.microsoft.com> wrote in message
Prob an easy one but is there a keyboard shortcut to select a whole range of
data (database) in excel. Or select just the filled in data. I know ctrl A
selects all - is there a variation on this?
any help greatly appreciated
You can use Ctrl * to select the current region
Regards Ron de Bruin
"rexmann" <email@example.com> wrote in message news:019FE07A-9C7D-4300-9137-646406AAAA48@microsoft.com...
> Hi all
> Prob an easy one but is there a keyboard shortcut to select a whole range ...Newbie Cell Reference Question...
I apologize if this question has been answered before, but I'm no
quite sure what to search for as I'm not very good with excel.
I'm making a spreadsheet where one sheet references another. I'll tr
to explain this as best as possible....
I'm creating a spreadsheet for a fantasy basketball league. I have
"Data" sheet that contains data for all players. I have another sheet
"Teams" that has all the players on each team. Column B contains th
players name, and column C contains a number that corresponds to th
row this player is on in the dat...Recovery after "do not save changes" selected accidently
I mistakenly clicked on "do not save changes" for a
worksheet (file) that i'd been working on (I thought a
different file was highlighted). As it turns out I had
not saved the original file in over a day, though the
autosave is set up.
is there any way to get my file back, or at least an
intermediate version, instead of one with a day's less of
Thanks very much for your help!
Sorry to say, but your day's work is gone.
Greeting from the Gulf Coast!
"Mayukh" <firstname.lastname@example.org> wrote in...Compressed Outlined Data Copy
I need to copy only the data that is compressed in Grouped rows and not all
the rows when they are expanded.
When I copy and paste the compressed data, I get all the data that is within
the group, and not just the compressed data. For example:
I need just the following (which is compressed):
Ship $ Line
$5,278.00 CYP Total
$133,122.00 TI Total
$34,660,135.00 Vic Total
$34,798,535.00 Grand Total
when I copy it (D2:E17, but only showing 5 lines because of the
compression), it pastes 16 lines:
Ship $ Line
$5,278.00 CYP Total
$...inverting data #2
Please help, I'm stuck! I conducted a survey where respondants each gave
answers to 30 questions using a Likert scale i.e. they answered either
1,2,3,4 or 5 to each question. The data is in the following form:
q1 q2 q3 q4 q5
1 2 4 2 1 2
2 4 1 2 1 4
3 4 4 2 1 4
4 2 3 2 2 5
5 2 3 4 5 3
My problem is that half of the questions were asked in a negative direction
to avoid possible response bias. For the answers to these questions, I need
to reverse the answers. If the repondant answered 1, I want to record 5, if 2
then 4, if 3 then 3, if 4 then 2, if 5 then 1. Is there an...Cell background shading in Excel
Why is it that the background shading colors available
under the Paintbucket Icon chjange from file to file?
Also, how can I add some of the colors to the paintbucket
that are availabe under the format/cells/pattern pulldown?
Colors are a Workbook-level property, so you can change the color
palette for any workbook. Choose Tools/Options/Colors... and modify the
colors to your hearts' content. You can also import another workbook's
color palette from that dialog.
Note however, that there are only 56 bins in the color palette, so you
can only use 56 colors at a time. The paint b...Sum every other cell?
I own a used-book shop. I have an Excel SS to track how many books pe
day I sell in each of 28 categories and the $$$ I take in for eac
category. So there's two columns for each day: #books & $$$.
therefore want to add every odd-numbered cell in a row to get the tota
number of books for a category in a given period of days and ever
even-numbered cell in the same row for the the total $$$. Is there
simple formula or function for this
bookmanjb's Profile: http://www.excelforum.com/member.php?acti...Retreiving data
We move mailbox on a new server but somethimes we receive the following
message: "outlook is retrieving data from the OLD exchange server"
Can anyone help me
On Thu, 1 Feb 2007 01:21:01 -0800, Damb0
>We move mailbox on a new server but somethimes we receive the following
>message: "outlook is retrieving data from the OLD exchange server"
>Can anyone help me
What steps did you do to decommission the old server? If you give us
an idea of the version of the old and new ones we can post the right
help ...ctrl A should select all in MS Excel 2003
In past versions of MS Excel, the keys [ctrl]&[a] used to select an entire
screen. In Excel 2003, pressing it once just selects a table or some
specific set of data. I have to press it twice now to select the entire
screen. It is not a big deal, but I prefer the original way it worked, hence
the name of the fucntion "select ALL". If users would like to select a
subset of data, a different set of keys should be used.
> In past versions of MS Ex...Help Required with Macro to Manipulate Data
I have a spreadsheet(s) with the following data on it (this is imported
from a text file)
A B C D
1 Branch Date Total
2 4501 030204 29
4 4501 030204 14
6 4502 030204 331
8 4502 030204 52
10 4503 030204 54
12 4503 030204 85
and what do you want to achieve :-)
"Alan T >" <<Alan.T.email@example.com> schrieb im
> I have a spreadsheet(s) with the following data on it (this is
...opening a powerpoint document which is protected by Information Rights Management
We have a Powerpoint 2007 document which some former employee in our
office created before he left a year ago. Now, we need to open it and
when we try it, the document mentions you don't have read permission for
this. Do you want to obtain permission from that person's organizational
email address which does not exist as he has left.
We tried to contact the former employee who does not have that document
with him at present.
Is there any way we can open the document? I don't know enough about
Information Rights Management(IRM), but understand like PGP it is a tool
I have Name, PO Box, street address, city, state, zip across a row in 6
I want to have this format in 1 cell:
City, State Zip
> I have Name, PO Box, street address, city, state, zip across a row in 6
> seperate cells/columns.
> I want to have this format in 1 cell:
> PO Box
> Street address
> City, State Zip
You do realize that this will screw up your ability to sort the data.
A better solution would be to describe what you want to do with the
data. You may not need it in the ...How do I format a cell to auto date
I would like to have a date automatically enter itself each time I open the
spreadsheet. Is there a way to do this? Any help would be appreciated.
Use a function like this one for todays date
Regards Ron de Bruin
"George" <George@discussions.microsoft.com> wrote in message news:7EF21130-EBD9-41C2-8CB5-5723BE40CBB1@microsoft.com...
>I would like to have a date automatically enter itself each time I open the
> spreadsheet. Is there a way to do this? Any help would be appreciated.
...Remove Data Format Change
I have a program that puts a database's data into an excel spreadsheet. The
problem is that Excel is constantly changing the numbers to dates, which
corrupts the data. I know I can switch the column data type to Text and that
will fix it, but the problem is that when the data is written to the
spreadsheet it overwrites that column data type and Excel does the formatting
that changes my data. How can I turn this off so Excel stops trying to
recognize data types and change their format? Please help because this is
causing major problems for us.
>>I have a ...Data
I can not see the entires I made for the past month. What
can I do?
In microsoft.public.money, Magnus wrote:
>I can not see the entires I made for the past month. What
>can I do?
I don't know what would cause that.
describes using -s switch. That is a simple safe thing to try.
These may not solve your problem, but they are what I would do. I
would also review my backup file situation.
...Repeating columns cuts off merged cells
I hope you can help because I can't find a solution to this one.
I've got a two page spreadsheet (side by side) and I'm trying to repeat
columns A & B because their row headings on the left and should only
appear when printed (split onto two pages) (as in print setup > columns
to repeat at left > $A:$B),
B57:I57 are merged and wrapped (another grief that merged wrapped cells
don't auto height, but that's for another day) and so are B58:I58 and
B59:I59 (footer things).
...... and when printed,
B57:I57, etc. cuts off on the second page and...