To set this up, go to Home Note: Columns in the spreadsheet are built as you add questions to the survey form.

Changes you make to the survey form are updated in the spreadsheet, unless you delete a question or change the order of questions on the form.

excel screen auto updating-85excel screen auto updating-43

You can now also draw free-form lines using the pencil for marking areas to keep or remove—no more being limited to drawing just straight lines.

LEARN MORE Updates for Get & Transform and the Power Query add-in See what's new and improved in the December 2016 feature update, Version 1612 (Build 7668.2066).

Lasso Select at your fingertips Excel now has Lasso Select , a free-form tool for selecting ink.

Drag with the tool to select a particular area of an ink drawing, and then you can manipulate that object as you wish.

LEARN MORE: SET PIVOTTABLE DEFAULT LAYOUT OPTION | CREATE AND FORMAT PIVOTTABLES WITH FREE TRAINING FROM LINKEDIN LEARNING Insert recent links Easily attach hyperlinks to recent cloud-based files or websites, and create meaningful display names for people using screen readers.

To add a link to a recently used file, on the Insert tab, choose Link and select any file from the displayed list.For more information, see Draw and write with ink in Office.Use your digital pen to select and change objects In Excel, with a digital pen, you can select an area without even tapping the selection tool on the ribbon.LEARN MORE Join the Excel Community Learn how to use Excel, discuss your work, share tips & tricks, and connect with experts who build and use the product.The community helps answer your product questions with responses from other knowledgeable community members.You and your colleagues can open and work on the same Excel workbook. When you co-author, you can see each other's changes quickly — in a matter of seconds.