Nifty Tips

Posts Tagged ‘Excel’

I have a spreadsheet and I want to have the column across the top and the row on the left scroll with me. It makes data easier to read/match up. I can freeze panes either across the top or on the left side but I can’t figure out both. How do I do this?

When I add a little string replacment macro using VBA (Alt-F11, etc) and save it, how do I make that macro available in som eother Excel file?

Currently I have to hit F9 everytime I enter equation for the spreadsheet to recalculate the cell values.

Hi,

I need to make an Excel formula on sheet1 that involves cells in Sheet2.

How to?

Thanks.

I’d like to set the value of a cell based on the whether another cell contains a certain string.

For example, if the word in cell A1 contains the “blah” string, then set this cell equal to 1.

Does anyone know how to do this?