Home > Forum Home > Analyzing Corporate Financial Data > Excel Selective viewing / editing Share

Excel Selective viewing / editing

Excel Help for Excel Selective Viewing / Editing in Analyzing Corporate Financial Data

Forum TopicPost Reply Login

Excel Selective Viewing / Editing

Rate this:
(3/5 from 1 vote)

My requirement is I should press control + a (or other combination) and it should make certain columns to hide at same time (not doing manually hide)

Second requirement is column A should be editable by certain users
and column c by another set.

Is their any in built feature in short selective viewing and editing.

 Posted by on
Replies - Displaying 1 to 1 of 1Order Replies By: Most recent | Chronological | Highest Rated
Rate this:
(3/5 from 1 vote)
There is no in built functionality in Excel to handle viewing and editing rights for individual users. However, this can be handled through VBA code on the Open event of the workbook. In this case, the user must enter login details and the protection is then dynamically set based on the use's credentials.You can find code for accomplishing this here.

To automatically hide and unhide columns or rows, the best method is to use grouping under Data > Outline > Group.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Excel Selective viewing / editing in the