Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to activate a cell if it contains data
I've created a Pvt Table which contains 6 fixed columns and it will show data
depends on how many columns I wanted to see. In addition, I've created another set of columns to copy data shown on the pvt table. So here is my question, is there a way to activate cells with data on the Pvt Table? Here is an example: If I wanted to see 4 columns of data on the Pvt Table: Column A Column B Column C Column D Column E Column F Row1 $27 $30 $49 Total My other Set of columns should appear like this: Column G Column H Column I Column J Column K Column L Row1 $27 $30 $49 Total I'm trying to insert a function, if a cell contains data, activate that cell, if it's a blank cell, dont show anything. I've tried =IF(A1="",+A1,0) but my function does not seem to work and I don't know the command for deactivate a cell (if there is any) so help is much appreciated. Joe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The cell I click on when coming from another app doesn't activate | Excel Discussion (Misc queries) | |||
My data validation cells don't activate when I click on them | Excel Worksheet Functions | |||
Activate cell at end of range | Setting up and Configuration of Excel | |||
activate a cell value through a macro | Excel Discussion (Misc queries) | |||
Activate Cell | Excel Discussion (Misc queries) |