LinkBack URL
About LinkBacks
HI,
Can anyone show me how to select cell form excel diagonally?
tq
HI,
Can anyone show me how to select cell form excel diagonally?
tq
I dont understand your question, did you mean select for example the A1, B2, C3, D4, etc? You can select the first one the press Ctrl and keep it, and the select the others.
http://excelmooc.com
Yes, but what is I have 500 line of data?
and I want to include formula in the cells
what exactly are you trying to do?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I want to do something like this (attached file) but with 500 lines of data
welcome to the forum, smurts. maybe this in F7?
=IF(ROWS(F$7:F7)=COLUMNS($F7:F7),$C7*(1-$C7),0)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks