RootsChat.Com
General => Technical Help => Topic started by: Rosinish on Tuesday 13 September 16 00:34 BST (UK)
-
Hi Folks,
I have noticed in the past, some sites such as RC (among others) only give the option of uploading info. in " txt, rtf, jpg, jpeg, gif, pdf, mpg, png, ged"
I have often had info. on excel (which I'd like to upload) but it isn't included in the options, for whatever reason I do not know?
I know I could transfer it to "word" which wouldn't look quite the same as it's not as neat & tidy but is that classed as "txt" as I don't see an option for "word" as in doc?
Annie
-
Here is a very small table from excel that I have just drawn up after reading your post. I have 'snipped' it using a standard accessory tool that I was first introduced to via RootsChat. It is the 'snipping tool' that Windows has in its Accessories option. (I am currently using Windows 7 Pro).
JM
-
Google
https://support.microsoft.com/en-au/help/13776/windows-use-snipping-tool-to-capture-screenshots
JM
-
Hi Annie - depending on your version of Excel, you should be able to Save As > PDF. I also recommend majm's suggestion of using the snipping tool to save it as a jpeg. Saving as .txt isn't the same as a Word doc, a .txt file has all formatting removed, opens in Notepad, and would be mostly used for transferring the data to other programs.
M :)
-
Thanks guys,
Not tried anything yet but I use Office 2003 & Vista if that helps?
Annie
Added...I also have XP with Office 2003
-
Thanks guys,
Not tried anything yet but I use Office 2003 & Vista if that helps?
Annie
Added...I also have XP with Office 2003
Unfortunately it looks like saving as a PDF isn't an option in Office 2003 as it was introduced in Office 2007.
Windows Vista should have the snipping tool (unless it's Vista Basic) but not XP.
See here for how to activate it or find it
http://www.pcworld.com/article/137099/article.html
Another way is to use the Printscreen button on the keyboard to capture what's on screen, then paste it into the Paint program. In Paint you can crop, resize and save as a jpeg
see here
https://www.youtube.com/watch?v=gc4GvcuL06g
Hope that helps!
M :)
-
It is possible to save excel to pdf.
You need to go to PRINT, and to select a pdf printer from the options so you effectively SAVE AS your excel file as a pdf. It does NOT update any changes made to the excel file after the pdf has been created.
If you do not find a pdf printer in your print options, you will need to download a pdf writer.
There are several free pdf printers. Here is a live link to the free Cute pdf writer.
http://www.cutepdf.com/Products/CutePDF/writer.asp
JM
-
This is a question I have been asking myself lately as I need to keep a reconstructed Excel file 'as is' in case my machine does funny things again with it ( a large file of Strays, where a couple of the columns jumped one or two lines, and it took weeks to sort it all out - thank God for Ryerson!)
I haven't tried yet, but I presume the pdf would only be of the visible worksheet?
i.e. I'd have to save each worksheet separately?
Dawn M
-
:) Yep :)
-
:) Yep :)
Does your printer have extra features .... We have a Brother MFC - J65200W
My husband suggests you print the excel files, and then re-scan them, saving them either as jpeg or as pdf (both are options with that printer), and then email them to yourself, as attachments for back ups.
JM PS, my OH says that my reply to you is the shortest post I have ever made at RChat. ::)
-
My husband suggests you print the excel files, and then re-scan them, saving them either as jpeg or as pdf (both are options with that printer), and then email them to yourself, as attachments for back ups.
Seems like an awful faff to make a backup. Plus you only get the raw data printed out - you don't get any formula, formatting, macros and have to reenter the data all over again should you lose your original. And it seems an awful waste of ink just to print something out for rescanning, although you do end up with a hard copy provided it doesn't get lost/damaged/destroyed.
If it works for you, then fine. But I'd suggest alternatives such as multiple copies on USB drives, CD/DVDs, "cloud" copies, etc.
-
I use an online program similar to microsoft excel but it's the google version.
Google docs won't actually let me save the document unless i download it and convert it to a PDF. I'm not sure if google docs works with windows but it's worth a shot if you have a tablet or chromebook.
-
Hi,
coming in late again, but I had a lot of trouble trying to convert Excel from PDF, so in the end I scanned the excel document as a photo (JPEG) - very slow, but I was able to print it out.
Bev
I have HP Office jet 4650
-
No - printing off, then scanning and saving is a ridiculous faff!
Newer versions of windows have the Snip tool - this is the easiest and quickest way of saving items from the screen as a JPEG. Look for it in the list of "apps".
If the Snip tool isn't present, use the screen dump facility. Along the top of your screen, there is a key that says "print screen", PRTSC" or similar. Depending on the version, you press this at the same time as either the function key or the ALT key, and it just copies everything that is on the screen. Paste this into any graphics package (Paint is the most basic, and comes with all Windows systems). Within Paint, you can trim your image down to whatever size you want. Very, very easy
Mike
-
The snip tool is my best friend!!! Why didn't I think of that before instead of going round and round and getting nowhere slowly.
I think the 'brain drains' are coming faster and faster as I get older and I cant catch up with them.
Bev
-
It sounds like your're already half way there and you have Vista which means your office 03 is upgradable if you havn't already had it upgraded.
The Microsoft Windows XP include this version of the Windows Installer in the operating system and will prompt you when available to upgrade office. If for some reason your vista hasn't upgraded office automatically then the latest version of Windows Installer is available as a separate download at the following locations: Windows Installer for Windows 95, 98, and ME Windows Installer for Windows NT 4.0 and 2000
Download the Update for Microsoft Office Outlook 2003 (KB2449798) to apply some minor bug fixes.
blah blah blah, don't worry about any of that for now...
You will know for sure that you need to update office if you copy from excel and the special paste option that opens a microsoft office excel object option are not options when you right click to paste in word.
SOOOOOO, when you right click to copy your excel doc in excel then right click in word to paste and the special paste option isn't displayed with the other paste option then office will need another upgrade.
If special paste option appears when you right click.....read on and good luck!
To embed an excel sheet into a word document you can try these steps:-
1. In Excel, click on the chart and do Edit > Copy (or, click on the chart and do ctrl-c). Or, select the cells you want to appear in your Word document and do Edit > Copy or ctrl-c.
2. Switch to Word
3. Now, click on Edit > Paste Special and choose Microsoft office excel chart object......
If all of that worked and you want to link your Excel doc and the Word doc (so the Word doc will convert and save whenever you work on the Excel doc. All editing/changes will be ''linked'' then click the Paste Link option). And click OK.
Oh, and if you want to hide any gridlines click on table->and click on hide gridlines.
Hope this helped and good Luck with it :)