DDD Posted October 22, 2020 Share Posted October 22, 2020 Hi, is there any way I can quickly apply a fomula to a whole column? Like the "cell dragging" in Excel? Thank you. Quote Link to comment
Pat Stanford Posted October 22, 2020 Share Posted October 22, 2020 Not as quick or as cool as Fill Down/Fill Right in Excel, but if you Copy a cell with a formula, then select a range you want the formula in, when you Paste the formula will be pasted into every cell with relative references (or absolute if the original cell specified absolute). Even slightly cooler is if you select a range of cells and Copy, then select a range and paste, the copied cells will be pasted in as many times as will fit. So if you copy cells containing: Happy Birthday and then you select a range of 7 cells you will get: Happy Birthday Happy Birthday Happy Birthday Happy HTH 1 Quote Link to comment
DDD Posted October 22, 2020 Author Share Posted October 22, 2020 @Pat Stanford Thank you! Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.