Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Can I make a cell in Excell flash or blink.

Also Can I only have it flash or blink when it has a negative number entered
or calculated


Post your answer or comment

comments powered by Disqus
can I make a field in excel spreadsheet required? If yes, How?

I am trying to make a cell in which the formula and the entry field are in
the same cell... In other words getting a formula to be locked in a cell to
where whatever info I put in the cell, the locked formula calculates the
entry number.

I have created a stored procedure that all i have to do is add the date at the end and it will call that information. I would like to Input the Date in a cell in Excel that will automatically change that information. How can I go about this? Thanks!

How can I hide a column in Excel that others I send the sheet or workbook to
cannot unhide, but can still add/modify other information in a sheet or
workbook?

I would like to have a formula in excel that checkes "date modified" of the
file and shows this in a cell, so a user opening a file can see when the file
was last saved/modified. I saw this when using SAP Business Warehouse tool
but it was probably part of the program. Is there a possibility to to
something like this with a normal excel file?

I am setting up a document in Excel and need to split a cell into two
additional cells, but they need to match with a previous row...I know you can
do it in Word, can this be done in Excel

I would like to have a formula in excel that checkes "date modified" of the
file and shows this in a cell, so a user opening a file can see when the file
was last saved/modified. I saw this when using SAP Business Warehouse tool
but it was probably part of the program. Is there a possibility to to
something like this with a normal excel file?

I wanna make a nomogram in excel, can sombebody help me??

I have a sheet which involves visits to clients.

Can I make a cell change color when I have completed a visit?

Cells are in date format. Need something really simple and visual to see each client.

Some suggestions, e.g. when I doubleclick the cell, or if I used a checkbox or something.

Thanks

I want to create a cell in excel to input the quantity to print so I don't
have to go to 'File' Print to put the quantity. Is that possible

I have a figure in a cell in excell and I would like to make this figure
flash on and off? Can it be done?

How can I make a confidence interval graph in Excel?

How can I make a cell or the font of the cell flash or blink? I assume that
it is a function of conditional formatting. I know it is possible because I
have seen it before but I do not know how to do it.

I know this may be a "DUH" question, but...

I am making a list of area dentists that I have copied and pasted off of the Dex website into Excel. I am wondering if I can take this info and make a database in Word for printing address labels. Does anyone know if this can be done, and HOW?

In excel, can you make a cell blink?

I want to add a graphic such as a signature to a cell in Excel so that it can
be used in a merge document. Is this possible.

Can you write a formula in excel that can reference the source/or dependent cells of a specific cell?

In other words: I label my tabs 1,2,3,etc. If I link cell A1 in tab 1 to cell A1 in tab two I would like to be able to write a formula in cell B1 of tab 1 that tells me that cell A1 is linked to tab 1. For a bonus I would like to be able to write a formula in C1 that tells me any cells that are using cell A1. For example if tab 3, A1 was linked to tab 1, A1.

To put it in to formula terms:

Cell A1 of tab "1" would look like this: ='2'!A2
Then I want to write a formula in Tab "1" Cell B1 that results in: "Tab 2" or even "Tab 2 Cell A2"

Can anyone help with this?

I have a formula that will put the name of a tab in a specific cell. This is great for tables of contents and creating titles to documents or footnotes, but it is a pain staking process to use this formula for the above purpose.

That formula looks like this:

=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,34)

I am currently using 2007.

Thanks to whoever is smart enought to figure this out!

Can I make a scrolling section of cells within a work sheet.?
What I am trying to do is make a section of cells scrollable within a work sheet.

Like say make 100 cells in 3 rows, but only display 10 of them on the screen and have a scroll bar to move down past the 10.

The idea is I want users to be able to inter a lot of data on these specific cells but I want to save room on the sheet for other things. Thanks.

I want to have a cell in Excel to blink on and off if it meets a certain
criteria.
Any ideas?

Hello i need urgently help:

how can i build a Matrix in Excel combining 250 items (ex. airports) with
250 items (ex. airports)?

i schould create a row with the 62500 possible combinations... there must be
a formula to make this autmatically.

ex. ZHR JFK ATL ....
ZHR
JFK
ATL
.....
And then I should get a list in one row :

ZHR-JFK
ZHR-ATL
......
JFL-ZHR
JFK-ATL
.....
ATL-ZHR
ATL-JFK

thank you very much for your help.

regards

Mischa

Basically I have made a banking application

but im trying to set a value to a cell in excel which has the code

=Value(F6)

but when a new line is inserted for every transaction, this also changes the code to Value(F7)

How can I keep it to set to just F6 please?

Also in VBA, I have allowed the user to finish the transaction and make another one however I get a error "form already displayed; can't show modally"

Thank you - you guys have been very helpful

What is a simple way I can split a cell in Excel? I have read several posts
regarding this, but they seem above my knowledge of the program. I already
have a spreadsheet set up and have a few cells that I need to split into 2 to
make them line up nicely with what I'm doing. HELP! Thanks!

I would like to know how to make a cell in Excel that is a list of a group of
items.

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.


No luck finding an answer? You could always try Google.