Ask Your Question
0

how do I make a spreadsheet with 31 pages of the same layout to be filled in later

asked 2020-10-18 16:11:54 +0200

SemiSeal gravatar image

I need to create a file that has up to 31 pages all the same (each to be one day in a month) so I can fill in different details for each day. How to I make a spreadsheet template that has all this to use again

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted
1

answered 2020-10-19 02:02:16 +0200

newbie-02 gravatar image

kiss: there is a function 'move or copy sheet' when you right-click on a sheet tab at the bottom of the screen, just define and layout one sheet, then use 'copy', and then change what's needed individually on the sheets,

ok?

edit flag offensive delete link more

Comments

Excellent thank you

SemiSeal gravatar imageSemiSeal ( 2020-10-19 13:19:21 +0200 )edit
0

answered 2020-10-19 13:20:23 +0200

SemiSeal gravatar image

My problem is solved thank you very much, copied and pasted by selecting all tabs

edit flag offensive delete link more
0

answered 2020-10-18 21:35:40 +0200

igorlius gravatar image

I would suggest, you create 1 Dolument with 2 sheets,

The 1st sheet holding the Layout+Style with placeholders (aka. marked insert points) The 2nd sheet holding the variable/insertable data together with an action switch to insert/autofill said data into the 1st sheet (on demand).

  • If you need more detailed instruction, just ask in the comments.

Hope that helps.

edit flag offensive delete link more

Comments

OK thank you

SemiSeal gravatar imageSemiSeal ( 2020-10-19 13:19:41 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-10-18 16:11:54 +0200

Seen: 72 times

Last updated: Oct 19 '20