Thanks to antville.org
mail merge separate file per record

Microsoft Word has an excellent feature called Mail-Merge. If the query returns more than one record (say 4 for the sake of the example), then the resulting Word file has multiple copies of the document merged together in one file. It is possible to have Word create a seperate file for each record using this add-on.

www.gmayor.com

... Link (0 comments) ... Comment


predictive typing

You can try a software called typing booster on Fedora. It helps user while typing. User can avoid typing mistakes and also avoid typing long spellings. If you are on fedora or centOS use the following command:

yum install ibus-typing-booster -y

I hope this package is made available for debian as well.

... Link (0 comments) ... Comment


Recover a Deleted Word Document

In Word, go to Tools, then Options. Under the File Locations tab, double-click AutoRecover files and make a note of that path location. Click Cancel and Close. Open up that folder in My Computer or Windows Explorer and search for any .ASD files.

... Link (0 comments) ... Comment


Saving Filtering Criteria

To save filtering criteria, use Custom Views:

Step 1: Add the Custom Views icon to the toolbar

  1. Place the mouse over one of the toolbars, right click, and select Customize from the shortcut menu.
  2. Select the Commands tab.
  3. From Categories, select View and drag the Custom Views icon to the Menu bar.

Step 2: Save the filtering criteria

  1. Select a cell from the column containing the criteria you want to Filter with.
  2. Click the AutoFilter icon
  3. Type any text criteria you want into the Custom Views box and click twice to save.
  4. Repeat the previous step and save as many filtering criteria as needed from any sheet within the workbook.

www.exceltip.com

... Link (0 comments) ... Comment


Returning the Smallest Non-Zero Value

I don't remember if I have mentioned this before, but if you want to return the Smallest Non-Zero Value, use array.
=MIN(IF(A1:A5=0,MAX(A1:A5),A1:A5))

(entered by pressing Ctrl+Shift+Enter)

You can make the formula even shorter by turning it around in this manner:
=MIN(IF(A1:A5<>0,A1:A5))

... Link (0 comments) ... Comment


Another old Excel bug

I have noticed an odd thing when it comes to creating CSV files with Excel: the files are not always consistent in how they end each row in the output data. When I create a CSV file that has, perhaps, 70 field (columns) of data and then views the CSV file in a text editor, I noticed that the records all contain carriage returns, but in different places. How do I get the CSV files to contain a consistent number of output fields.

This is actually a problem that has been known to Microsoft for quite some time. The Microsoft Knowledge Base includes an article on this topic as early as Excel 97:

support.microsoft.com

tinyurl.com

... Link (0 comments) ... Comment


Disable Paste Options

Excel include a feature that really annoys some people: Paste Options. When you paste some tidbit of information in your worksheet, Excel displays a small, floating "button" right near the end of the pasted information. Follow these steps to turn it off:

  1. Choose Options from the Tools menu. Excel displays the Options dialog box.
  2. Make sure the Edit tab is displayed.
  3. Clear the Show Paste Options Buttons check box.
  4. Click on OK.

... Link (0 comments) ... Comment


Finding a line break

how to search for a line break (Alt+Enter) in a cell?
Press Ctrl+F to display the Find tab of the Find and Replace dialog box. In the Find What box, hold down the Alt key as you type 0010 on the numeric keypad.

tinyurl.com

... Link (0 comments) ... Comment


Printing a Multi-Line Footer

You can create a multi-line header or footer in Excel. The trick is to remember that you cannot press Enter while typing your footer. Instead, to start a new line you should hold down the Alt key as you type 0010 on the numeric keypad. This inserts a line-break character in the footer text. The total length of a header or footer cannot exceed 255 characters.

... Link (0 comments) ... Comment


Picking Up in the Last Document Edited

you can jump to the last place that you edited in a document by pressing the Shift+F5 key. In other words, open the document, press the shortcut, and the insertion point jumps directly to the last edit point in the document.

... Link (0 comments) ... Comment


Online for 6367 days
Last modified: 1/29/20 11:15 AM
Status
Youre not logged in ... Login
Menu
... Home
... Tags

Search
Calendar
January 2020
SunMonTueWedThuFriSat
1234
567891011
12131415161718
19202122232425
262728293031
December
Recent updates
LibreOffice version conflict I am
not able to install latest version of Libre office. I...
by shantanuo (1/29/20 11:15 AM)
Amazing! Yeahh! you have an
informative blog so far. Thanks for sharing | roof repair...
by Danielperez123 (1/28/20 8:32 PM)
Great Work Thanks for sharing
the post. Microsoft toolkit
by talisasoto1989 (1/27/20 10:22 PM)
Farnham Carpet Cleaning Thanks Farnham
Carpet Cleaning
by Dubs@gl.com (1/27/20 10:13 PM)
Locksmith Guildford That's an interesting
point Locksmith in Guildford
by Dubs@gl.com (1/27/20 10:11 PM)
while loop This is
a sample shell script while loop while read mydb do echo...
by shantanuo (1/26/20 2:24 PM)
compare mysql schema And here
is poor man's schema compare using good old diff command......
by shantanuo (1/26/20 1:49 PM)
Selecting from error log grep
"error" error_log |awk -F[ {'print $4'} \ | sort |...
by shantanuo (1/26/20 12:40 PM)
Rank mysql records using variables
SET @rank = 0, @prev_val = NULL; SELECT rank, correct...
by shantanuo (1/26/20 11:45 AM)
Thanks for sharing this!!
commercial roofing huntsville al
by Mazikeen (1/24/20 6:37 PM)
Sophie Chciałbym więcej o tym
przeczytać. Szybka, jaka literatura ma studiować? texas colleges and universities
by panistefanin (1/24/20 3:45 PM)
Jack Lovely information thank you
very much decanters
by decanter2020 (1/24/20 1:20 PM)
I like it I like
that logic. interior painting
by LisaCook (1/23/20 10:11 PM)
Love it I like this!
Thanks for posting roll off canister
by LaurenHill (1/23/20 10:05 PM)
Thanks for the heads up!
Thank you for sharing this. Our website
by mozaic (1/23/20 2:32 PM)
Thank you for sharing
a really great piece of information. bubble shooter
by longjumper (1/21/20 11:05 AM)
Thanks Thanks for sharing these.
Sam H - Interior Painter Scaumburg Il
by Samh2019 (1/21/20 10:14 AM)
Fencing in Guildford thanks for
the information Fencing in Guildford Fencing in Surrey
by Dubs (1/20/20 9:26 PM)
satta matka matka boss satta
matka Visit our site for more information
by sattamatka3.net (1/20/20 7:52 PM)
Beebeetravvel Thanks for sharing your
valuable information. we are a tour & travel agency with...
by coolexusa (1/20/20 2:27 PM)
Access Control System Dubai Fingerprintdubai
Company is providing many types of Services like , card...
by coolexusa (1/20/20 12:19 PM)
Air Duct Cleaning This type
of Duct cleaning Miami is absolutely not a must have...
by coolexusa (1/20/20 11:26 AM)
Carpet Cleaning Oxford and Surrounding
Areas Interesting read. Carpet cleaning in Oxford and surrounding areas
by Murray Whelehan (1/19/20 8:18 PM)
Antares AutoTune Crack License
Key With Keygen ( MAC ) A Antares AutoTune Pro Crack...
by ijicrackgh (1/19/20 9:50 AM)
Waves Tune Real-Time Crack (Latest)
Free Download 2020! Visit my site and free crack full...
by ijicrackgh (1/19/20 9:45 AM)

RSS feed

Made with Antville
Helma Object Publisher