Ian's Excel Add-in Ribbon Menu

Fill page with blank lines

  • Mareli
  • Topic Author
  • Visitor
  • Visitor
7 years 8 months ago #1 by Mareli
Fill page with blank lines was created by Mareli
Ian

Does this addin have a function or macro to fill a bill with blank lines if it shorter than a full page?

When I insert page breaks for a new bill and the bill is not a full page then I have to manually insert lines before the Carried to summary total to make the bills look uniform with each page filled up. I've seen macros in excel to do this function.
Is it something mentioned or asked before?
Would you consider incorporating this idea?

Mareli

Please Log in to join the conversation.

More
7 years 8 months ago #2 by Ian
Replied by Ian on topic Fill page with blank lines
Hi Mareli,

Thank you for your post.

While there is no such macro in the current version of the addin, it does form part of the next major update to the addin. The whole process of totalling individual bills, summaries, etc. is being looked at.

Kind regards,
Ian

Please Log in to join the conversation.

  • Mareli
  • Topic Author
  • Visitor
  • Visitor
5 years 6 months ago #3 by Mareli
Replied by Mareli on topic Fill page with blank lines
Hi Ian,

Have it been considered to add a function to fill the bills with blank lines?

Regards

Mareli

Please Log in to join the conversation.

More
5 years 6 months ago #4 by Ian
Replied by Ian on topic Fill page with blank lines
Hi Mareli,

There is no fully automated process yet, but I may have an interim solution which could be of use to you.

I'll provide details in the next few days.

Kind regards,
Ian

Please Log in to join the conversation.

More
5 years 6 months ago #5 by Ian
Replied by Ian on topic Fill page with blank lines
Hi Mareli,

The upcoming update of the addin, due to be released on 15 September, has the ability to insert blank rows to push content onto the next page.

Place the cursor in the row that you want to be the first row on the new page, select the Next Page icon from the addin menu, then give it a moment or two to complete. This needs to be repeated for each new page you want to create.



Let me know how it goes. All feedback is welcome.

Regards,
Ian

Please Log in to join the conversation.

  • Mareli
  • Topic Author
  • Visitor
  • Visitor
5 years 4 months ago #6 by Mareli
Replied by Mareli on topic Fill page with blank lines
Hi Ian,

Thank you for adding this function, it works perfectly.

Regards
Mareli

Please Log in to join the conversation.

Powered by Kunena Forum
We use cookies

We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.