Agregador de necesitomas.comhttp://www.necesitomas.com/aggregator
necesitomas.com - canales de noticias agregadosesAllen Wyatt's Word tips: Entering a Name in the Header of a Locked Formhttps://word.tips.net/T007830_Entering_a_Name_in_the_Header_of_a_Locked_Form.html?dn=1
<p>When you lock a document as a form, then Word limits what you can do with that document. That includes not being able to change whatever is in the header and footer. This tip explains how you can bypass the need for putting a form field in an area of the document you can't change once the form is protected.</p>
<p>Read this WordTip: <a href="https://word.tips.net/T007830_Entering_a_Name_in_the_Header_of_a_Locked_Form.html?dn=1">Entering a Name in the Header of a Locked Form</a><br/>
<a href="https://word.tips.net">Microsoft Word Tips</a> -
<a href="https://word.tips.net">Learn Word Faster!</a></p>Fri, 13 Sep 2019 20:20:02 +0000Allen Wyatt's Excel tips: Multiple Line Headers and Footershttps://excel.tips.net/T001992_Multiple_Line_Headers_and_Footers.html?dn=5
<p>When working with headers and footers in a macro, you might find this tip helpful. It describes how you can create headers or footers that occupy multiple lines.</p>
<p>Read this ExcelTip: <a href="https://excel.tips.net/T001992_Multiple_Line_Headers_and_Footers.html?dn=5">Multiple Line Headers and Footers</a><br/>
<a href="https://excel.tips.net">Microsoft Excel Tips</a> -
<a href="https://excel.tips.net">Learn Excel Faster!</a></p>Fri, 13 Sep 2019 20:20:02 +0000Excel guru: Power Query Challenge 7 – Phone Wordshttps://www.excelguru.ca/blog/2019/09/13/power-query-challenge-7-phone-words/
Yesterday, Nick (one of our forum users) posted a Phone Words challenge in our forum, which looks like a great candidate for Power Query Challenge #7. I haven't had time to tackle it myself, but if...<br/>
<br/>
continue reading...Fri, 13 Sep 2019 16:45:09 +0000Allen Wyatt's Word tips: Specifying Sub-entries in an AutoMark Filehttps://word.tips.net/T001731_Specifying_Subentries_in_an_AutoMark_File.html?dn=2
<p>An AutoMark file allows you to quickly and easily create an index from a document. This can be a great boon for large documents. This tip explains more fully what an AutoMark file is, how to use the file, and how it should be put together.</p>
<p>Read this WordTip: <a href="https://word.tips.net/T001731_Specifying_Subentries_in_an_AutoMark_File.html?dn=2">Specifying Sub-entries in an AutoMark File</a><br/>
<a href="https://word.tips.net">Microsoft Word Tips</a> -
<a href="https://word.tips.net">Learn Word Faster!</a></p>Thu, 12 Sep 2019 20:20:02 +0000Allen Wyatt's Excel tips: Using Custom Add-Inshttps://excel.tips.net/T002277_Using_Custom_AddIns.html?dn=3
<p>Once you've created your custom add-in, you need to know how you or other people can use it. Here are the simple steps to making your add-in part of Excel.</p>
<p>Read this ExcelTip: <a href="https://excel.tips.net/T002277_Using_Custom_AddIns.html?dn=3">Using Custom Add-Ins</a><br/>
<a href="https://excel.tips.net">Microsoft Excel Tips</a> -
<a href="https://excel.tips.net">Learn Excel Faster!</a></p>Thu, 12 Sep 2019 20:20:01 +0000Chandoo (Pointy Haired Dilbert): #awesome trick – Extract word by position using FILTERXML()http://feedproxy.google.com/~r/PointyHairedDilbert/~3/9F8uHGuw-K0/
This is CRAZY!!!. I stumbled on a weird use for FILTERXML() while reading a forum post earlier today. So I couldn't wait to test it. I am happy to share the results.
Say you have some text (sentence...<br/>
<br/>
continue reading...Thu, 12 Sep 2019 10:03:30 +0000Allen Wyatt's Word tips: Collapsing and Expanding Subdocumentshttps://word.tips.net/T000882_Collapsing_and_Expanding_Subdocuments.html?dn=4
<p>Working with subdocuments is easier if you understand how to collapse and expand them. Here are the techniques you can use.</p>
<p>Read this WordTip: <a href="https://word.tips.net/T000882_Collapsing_and_Expanding_Subdocuments.html?dn=4">Collapsing and Expanding Subdocuments</a><br/>
<a href="https://word.tips.net">Microsoft Word Tips</a> -
<a href="https://word.tips.net">Learn Word Faster!</a></p>Wed, 11 Sep 2019 20:20:02 +0000Allen Wyatt's Excel tips: Setting Print Ranges for Multiple Worksheetshttps://excel.tips.net/T003157_Setting_Print_Ranges_for_Multiple_Worksheets.html?dn=3
<p>Need the same print range set for different worksheets in the same workbook? It can't be done in one step manually, but you can use a macro to make the print ranges the same.</p>
<p>Read this ExcelTip: <a href="https://excel.tips.net/T003157_Setting_Print_Ranges_for_Multiple_Worksheets.html?dn=3">Setting Print Ranges for Multiple Worksheets</a><br/>
<a href="https://excel.tips.net">Microsoft Excel Tips</a> -
<a href="https://excel.tips.net">Learn Excel Faster!</a></p>Wed, 11 Sep 2019 20:20:01 +0000Chandoo (Pointy Haired Dilbert): Show difference between cells in status bar – VBA Examplehttp://feedproxy.google.com/~r/PointyHairedDilbert/~3/-jF8R7L8ye4/
We can select a few cells in Excel and quickly see their count, sum etc. in the status bar. Ever wanted to customize the status bar to show something else, say difference? You can use VBA add-ins...<br/>
<br/>
continue reading...Tue, 10 Sep 2019 21:53:22 +0000Allen Wyatt's Word tips: Determining the Size of a Filehttps://word.tips.net/T000820_Determining_the_Size_of_a_File.html?dn=3
<p>When processing a document using a macro, you may need to know the precise size of a particular file. The way you figure this out is to use the FileLen function, described in this tip.</p>
<p>Read this WordTip: <a href="https://word.tips.net/T000820_Determining_the_Size_of_a_File.html?dn=3">Determining the Size of a File</a><br/>
<a href="https://word.tips.net">Microsoft Word Tips</a> -
<a href="https://word.tips.net">Learn Word Faster!</a></p>Tue, 10 Sep 2019 20:20:02 +0000