Share via

Building blocks in Excel

Anonymous
2020-09-14T21:17:48+00:00

In MS Word 365 there is an option to save a string to a "building block". The procedure is to select the string and press ALT-F3. You are presented with a "CREATE NEW BUILDING BLOCK" dialog box containing the selected string and an option to "OK". If you choose OK the string is saved. The next time you start to type the same string, Word will autocomplete the string whereupon you can accept it by pressing ENTER or reject it by continuing typing.

Can this be done in Excel?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-09-15T01:14:22+00:00

    Hello Deuxdad! I'm Jen, an independent advisor and a fellow Microsoft user like you. I'd be happy to help you out with this issue.

    The Excel application and the Word application are different. Currently, there is no such Building Blocks feature in the Excel application like the Word application. What I can suggest to you for now is to raise this concern through Excel Uservoice forum.

    https://excel.uservoice.com/forums/304921-excel...

    This is an official platform where users can send suggestions and ideas to improve their product. We hope you can raise your concerns here.

    Thank you for your understanding. Stay safe and healthy!

    Kind Regards,

    Jen :)

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments