Free Microsoft Excel 2013 Quick Reference

How can i jump to a cell referenced in a formula?

Anyone know of a way to jump to a cell referenced in a formula, when it is
not the first reference...e.g. Formula bar reads
"=D5+G5"
CTRL+{ will take me to D5 but is there a way to get to G5 easily? Especially
helpful in long formulas and off sheet links.

thanks


Anyone know of a way to jump to a cell referenced in a formula, when it is
not the first reference...e.g. Formula bar reads
"=D5+G5"
CTRL+{ will take me to D5 but is there a way to get to G5 easily? Especially
helpful in long formulas and off sheet links.

thanks

I have a annual leave spreadsheet where I want the user to enter a number
from 1-8 which will change the colour of the cell. Is this possible? How many
conditions can I apply to a cell? I need to apply 8.

Thanks in advance

Markus

How can I conditionally format a cell based on the value in a different cell.

I have two columns of information. None of the information in the cells I am
trying to format is numeric. I am trying to track names to loans that are
with the company. If they wrote outside, I need to keep track of which other
company it was written with.

The First column currently has a conditional format to highlight the cell if
the value is = "Home". The other values that are entered are variations of
"Outside". I have to keep the variations as they are, in order to track which
loans went with which other company.

The second column has the borrowers name. I need this column to highlight
the cells if the loan was written outside.

So if the cell is highlighted in column A, it should not be highlighted in
the column B.
And Vice versa.

How can I tell if a cell contains a formula versus a number or text? (apart
from looking at it). i want to create a conditional format for cells so that
if users enter a formula (or reference to another cell - basically anything
starting with "=" , it appears in a different format.

How can I hyperlink to a telnet session?

how can I e mail a single worksheet in excel 2007

Easy question...how can I refer to a cell (Ex. B22)in VBA programing like I do when writing formulas?

Hi,

Please advise how I can create Hyperlink to a hidden sheet in a same workbook.

Thanks.. Aman

I want to create a macro which insert 8 row and cursor move two row above automatically.
Code of inserting 8 rows is

'
Selection.EntireRow.Insert
Selection.EntireRow.Insert
Selection.EntireRow.Insert
Selection.EntireRow.Insert
Selection.EntireRow.Insert
Selection.EntireRow.Insert
Selection.EntireRow.Insert
Selection.EntireRow.Insert
End Sub

How can i move cursor two row above in above code.?.

hi,

I have many workbooks which have 8-9 sheets each. All identical as an
e.g each work book represents a company and each sheet has some
financial data for that company.

I am adding a new sheet which has charts and formulas which refrence
other sheets in the same workbook.

I want to replicate this sheet in all other workbooks but the formulas
and charts need to refrence the sheets in the local workbook. But when
I copy and paste all the data is refrenced from the original sheet and
I have to fix every data point and this is very cumbersome and
ineffcieint. Is there some way to do this easily ?

thanks,

Arun

How can i able to print all the excel formulas.

Hey,

how can I scroll to a specific position in the excel sheet with a macro?

Thx!

How do I set up a cell whitch should be suggested as the file name to save
when "SAVE AS" is clicked?
For example on a worksheet
B2 is a date,(AUG-1-05)
A1="SCHEDULE FOR "&YEAR(B2)&MONTH(B2)&DAY(B2)
A1 will be "SCHEDULE FOR 200581"
On the window that opens after clicking on "SAVE AS", how I can do, to bring
"SCHEDULE FOR 200581" to the box of the suggested file name to save.
Thanks.

in an alphabetized list how can i type a letter and have it go to the first
cell in the list that contains that letter?

How do I set up a cell in MS Excel 2003 to blink? I'm sure it's relatively
simple.

I've got one Excel 2003 file used to maintain a newspaper delivery list.
Four customers have billing needs apart from the norm. I'd like to be able
to make these 4 jump out at me.

I do have very limited experience with Visual Basic in editing a few macros
for a specific MS Excel file used to maintian my pilot's logbook, but that's
it.

Any help would be most welcomed.

Thanks.

Hello!!

If I have in a worksheet a integer value (that may be changed), let's call it myNum, and in another worksheet a column containing numbers from 0 to 350, each row contains my data to be analysed, how can I use myNum to obtain an index that refers to that specifc row?? I hope it is clear!!!

If not please do tell me and I will use an example.

Thanks

Gianlu

I've created a mask, in which I can update a field. If the value that i'm inserting already exists in a table, i see a message error (duplicated value,etc) and Access automatically enables the near field.
I need to fix this: how can I enable the first control, the one in which I'm trying to insert the value?

How can I set up a Macro to automatically run when I open a specific Excel
file?

how can i select all the cells with same color on a sheet if there are
multipale colors by vba code

How do I easily go to a cell referenced in a formula? The
precedents/dependents is useful when the reference is on the same
spreadsheet, but not so easy when the referenced cell is on another
spreadsheet - even if in the same file.

Thanks much for your help!

How can I format an Excel cell with a "save" or other command?

How can I refer to a cell in a formula by concatenating the column reference from one cell with the row reference from another cell?

Specifically, I have several rows with Name, Address, Phone, etc. I want to enter a row number in a cell near the top of my sheet and have my summary row display all of the information in only the referenced row.

This seems like it should be basic, but the answer eludes me, even after using online help, Google, my experience, and common sense.

Hello,
I would like to know how can i write 2 lines of text in one cell?
i know that if i write a long sentence and wrap the text it will look the same
but there is another way?

thanks

Cell C1 can have any one of the following values: Light, Medium, Heavy, Super Heavy. In A1, I want to add 5 if C1 is light, add 7 if C1 is Medium, add 10 if C1 is Heavy, and add 13 if C1 is Super Heavy.

How can I accomplish this?

Thanks
Ocean