Thursday, April 10th, 2014

Make a Style that forces a page break in Word

word style with built in page break Make a Style that forces a page break in Word

If you always start a new page for a particular type of heading – include the page break in the style

When you always start a major heading item on a new page in a Word document you can configure your heading style so it has the page break built into it – saving  you having to insert it manually.

To do this, select some text with formatted with the style that is to include the page break and locate the style in the Style gallery. If it does not appear there, display the Styles and Formatting task pane by clicking the dialog launcher in the bottom right of the Styles area in the ribbon.

Right click the Style name, choose Modify and then Format.

Click the Paragraph option and then click the Line and Page Breaks tab.

Enable the Page Break Before checkbox and click Ok twice.

The page break is now part of the style so a new page will be started each time you use that style. The style will also update and effect any text already formatted using that style in the current document.

Helen Bradley

Wednesday, March 26th, 2014

Play and Burn DVDs in Windows 8

dvdimage Play and Burn DVDs in Windows 8© ugaldew, sxc.hu

If you’re using Windows 8 or 8.1 you can play videos and movie files you have stored on your computer but you can’t view DVDs using Windows Media Player—this feature was removed from Windows 8 along with the Media Guide.  If you want to be able to play DVDs in Windows 8 you will need to download and install a DVD player. If you’re using Windows 8 Pro then you can download and install Microsoft’s Windows Media Center which costs $9.99 – this site will step through the process. If you’re not using the Pro version then you would need to upgrade to Pro to use the Media Center, which ends up being a $100 upgrade  just for the ability to play a DVD. Instead, I recommend you use the free VLC Media Player.

If you need to burn DVDs you will need a DVD burner to do so. Windows 8 doesn’t ship with a DVD burner but that doesn’t mean that the manufacturer of your computer hasn’t provided one. Check the Start screen and see if there’s a DVD burner already installed. If not, here is a round up of some of the DVD burning tools around which are Windows 8 compatible. The good news is that most have free trial versions so you can test them out and see how they perform:

Wondershare DVD Creator — $39.95

Ashampoo Burning Studio Free — upgrade to full version for $49.99

Aimersoft DVD Maker for Windows – $39.95

Nero Burning ROM 12 – $49.99

 

Helen Bradley

Helen Bradley

Sunday, March 23rd, 2014

Easily Paste Web Content into Excel with Destination Formatting

opener Easily Paste Web Content into Excel with Destination Formatting

When pasting large data tables from your web browser into an Excel file you’ll probably be displeased to find that they do not match the formatting of the worksheet.

By default Excel will paste the data with the formatting it used on the source web page instead. This is rarely useful, since it’s very unlikely the web page had formatting that is compatible with your document. As you can see in the image above, using the source formatting can result in the inclusion of links, improper font and font size, and a number of other formatting issues.

To make Excel paste the data with destination formatting (i.e. the formatting of the destination Excel worksheet), you’ll need to add a special command to your quick access toolbar. To do this, select File > Options > Quick Access Toolbar. Above the left column, select the Choose commands from dropdown and choose All Commands. Scroll down the list and find Paste and Match Destination Formatting. Select it and click Add, then OK.

qat Easily Paste Web Content into Excel with Destination Formatting

Now whenever you wish to paste web data into Excel, click the Paste and Match Destination Formatting button in the Quick Access Toolbar instead of using the standard paste tool. This will result in the data being automatically formatted to match the look of the rest of your worksheet.

Helen Bradley

Helen Bradley

Friday, March 21st, 2014

How to Fix Excel Printing a Workbook to Multiple PDF Files

image opener How to Fix Excel Printing a Workbook to Multiple PDF Files

Learn how to  make sure that printing multiple sheets to a pdf gives one pdf and not many

If you have ever tried to print a large Excel workbook to a PDF file, you’ve probably run into this issue. You press print, Excel asks you to name the PDF, and then it begins to print. Everything seems fine, but then Excel asks you to name another PDF, then another, then another, ad infinitum. When the operation finally finishes, Excel has properly printed the workbook to a PDF format, but your worksheets have been split into several different PDF files. Some PDFs contain multiple worksheets, others only a single one, but all you really wanted was one PDF file with the entire workbook.

It turns out this issue is caused by having different Page Setup options on each worksheet. For example, Excel can’t print two pages with different paper sizes to the same “piece of paper” (actually a PDF in this case). Instead, it insists on having two different PDFs to print to, one for each paper size. So, to resolve this issue, you must make sure each worksheet’s page setup agrees with the others.

Fortunately, doing this is very simple. To begin, in your Excel workbook, right click one of your worksheet tabs at the bottom of the window and choose Select All Sheets. Any changes to the Page Setup options will now be applied to every worksheet.

image 2 How to Fix Excel Printing a Workbook to Multiple PDF Files

This means we don’t have to check each worksheet to make sure it has the same settings as the others; we simply choose which settings we want and all the worksheets will automatically match. To do this, go to the Page Layout tab in the ribbon. In the Page Setup section, click the small arrow in the bottom right corner to open the Page Setup dialog.

image 1 How to Fix Excel Printing a Workbook to Multiple PDF Files

The Page tab of the dialog contains the critical options that can lead to this issue, namely the paper size and print quality settings. Change these to whatever you wish, typically something like letter paper at 300 dpi. Other settings, such as orientation and scaling, do not cause the multiple PDFs issue so if you wish you can change them for individual worksheets. Still, it’s best to have all worksheets print with the same settings. Once you have chosen your desired settings click OK and they will be applied to every worksheet.

image 3 How to Fix Excel Printing a Workbook to Multiple PDF Files

You can now print your workbook to a single PDF file.

Helen Bradley

Thursday, March 20th, 2014

Create Your First Access Database – Pt 4 – Report Design

Database in Microsoft Access

Learn to create a database in Microsoft Access. This video steps you through the process of creating a report for your Access database file. In other parts of this series you can learn how to create the database, write Queries and create a Form for easier data entry.

For a text version of this video check out this article on my website: First Steps with Access

Helen Bradley

Monday, March 10th, 2014

Format Sticky Notes – Learn the Hidden Secrets

sticky notes how to format text 2 Format Sticky Notes   Learn the Hidden Secrets

Learn these quick techniques to format your Sticky Notes

I love using sticky notes to stick things to my desktop. Using these on my digital desktop is helping keep my real desktop clean and tidy. However, sometimes I need to format my notes and help for doing this is not easy to find. So, here, in a nutshell, are the super secret shortcut keys you can use to format your text on your sticky notes :

Bold                     Ctrl+B
Italic                   Ctrl+I
Underlined               Ctrl+U
Strikethrough            Ctrl+T
Bullet list              Ctrl+Shift+L 
    (press this twice for a numbered list)
Subscript                Ctrl+= 
Superscript              Ctrl+Shift++ 
Increase/Decrease font size
                        Ctrl+Shift+> and Ctrl+Shift+<
                        (or Ctrl+Scroll wheel)
Single space lines      Ctrl+1
Double space            Ctrl+2
1.5 Line spacing        Ctrl+5
Captialize Text         Ctrl+Shift+A 
Right Align             Ctrl+R
Left Align              Ctrl+L
Center Align            Ctrl+E

You can also use fancy effects in sticky notes if you create them in another application such as Word and then copy and paste them into the Sticky Note.

Other handy Sticky Notes keyboard shortcuts:

Undo                    Ctrl+Z
Redo                    Ctrl+Y
Cut                     Ctrl+X
Copy                    Ctrl+C
Paste                   Ctrl+V
New Note                Ctrl+N

To change the color of a note, right click it and choose a color.

sticky notes how to format text 1 Format Sticky Notes   Learn the Hidden Secrets

To Backup your Sticky Notes:

You will find your Sticky notes file at
c:\users\<username>\AppData\Roaming\Microsoft\Sticky Notes

To make a backup, copy the stickynotes.snt file you find there.

sticky notes how to find to backup Format Sticky Notes   Learn the Hidden Secrets

To launch Sticky Notes if you haven’t yet discovered them:

Start > All Programs > Accessories > Sticky Notes

 

Helen Bradley

Wednesday, February 26th, 2014

Excel – Replace charts with pictures

Enhance your Charts with Visuals

by Helen Bradley
Why have boring old column and bar charts when you can have picture charts instead?

Learn how to replace bars and columns in Excel charts with small images stacked up to show the values being compared.

Image charts like this are one of Excel’s secrets so let me show you how to make them.

In the video you will learn how to replace columns and bars in Excel charts with images. You will see how to find images to use and how to stack and resize the images to fit the chart’s columns and bars.

Helen Bradley

Friday, January 31st, 2014

Mac lock and display dimming timing

Memo to my Mac – Don’t go to sleep on me!

Hmmm me and my MacBook Air are getting along pretty well but some things still bug me from time to time.

One is the display dim time. You see it seems like I just look away and all of a sudden the Mac has gone elsewhere – the screen turns off and I have to wake it back up and enter my password.

Right now I am trying to download some software so this is getting pretty annoying. I want to be able to see the progress without having to the Mac up all the time. This constant jiggling the touchpad and entering  a password is becoming frustrating.

Seems like there are a couple of settings needing changing. One is in Settings > Security & Privacy. If I set the Require Password value to something more than Immediately I will get some leeway in having to enter my password all the time. I set this to 1 hour. But, the screen is still dimmed after only a minute or so. That setting is in Settings > Energy Saver – there you can set the Display Sleep – mine was set to 1.5 minutes – I ramped that up to 1 hour.

So now my Mac doesn’t go to sleep when I am downloading stuff on it and working on another computer and I don’t have to enter my password like every few minutes. In short, life is a lot simpler.

Hope this helps you and your Mac to be friends again?

Helen Bradley

Saturday, January 11th, 2014

Hide everything and show the Mac desktop

How to display your desktop – hiding all open programs on the Mac

I am in ‘traveling with my Mac mode’ – I have a MacBook Air and it is so light and thin that it makes a great traveling companion – sort of like having an oversize iPad that runs Illustrator, Photoshop and Lightroom.

BUT, and there are some big buts! I use a desktop PC so little things on the Mac bite me because I simply don’t have the knowledge at my fingertips. In the last couple of days the issue has been the desktop – I need to get to some files saved there but there is all this stuff in the way. Turns out there is a shortcut key you can use – F11 – if you’re on a notebook you’ll need to use the Fn function key with this so it is Fn + F11 but that’s all you need to hide everything and show your desktop.

Now I can take my screenshots Command + Shift + 3 then hide the junk so I can see the image to drag and drop it into a Word document or into Photoshop.

Yeah! Me and my Mac are friends again.

 

Helen Bradley

Thursday, January 9th, 2014

Format Painter missing in Word on the Mac

format painter missing in word on the Mac Format Painter missing in Word on the Mac

It’s actually not missing but it’s not where you expect to find it either.

I use Word on the PC every day and on the Mac only when I am traveling – I love my MacBook Air with its solid state drive – it’s light and an easy traveling companion.

What I don’t like is having to work out all the curly questions you have when things work differently in one operating system to another. Cue today’s issue. I was copying and pasting content from my website into Word on the Mac and I needed to remove the formatting – well I found the Clear Formatting button sort of where I expected it to be on the ribbon.

But when it came to copying a format from one piece of text to another I got stumped. You see the Format Painter isn’t on the ribbon where you expect it to be if you’re used to using Word on the PC. In fact Word on the Mac is a totally different animal.

To find the Format Painter look upwards – up from the ribbon, up from the ribbon tabs and up to what we Windows folk would call the QAT or Quick Access Toolbar. On that toolbar of tools in Word on the Mac is the Format Painter. Click the text to copy the format from, click the Format Painter and then click the text to paint it onto. It’s a simple process BUT you have to find the Format Painter button first!

Hopefully this helps you!

 

Helen Bradley

Sunday, December 1st, 2013

Google Kills Spreadsheet Gadgets

google docs google drive map gadget e1385596537562 Google Kills Spreadsheet Gadgets

This is the old map gadget from Google – it doesn’t exist any more and the maps created using it won’t exist soon either.

If you’re asking yourself: What happened to Google Docs Gadgets? – the answer isn’t anything you want to hear

I loved Google Drive (formerly Google Docs) gadgets. These were advanced options you could use with Google spreadsheets.

There was a Motion Chart gadget which helped you to create a great looking motion chart. You could set it up the way you wanted it to look and save those settings to the defaults. Click Publish and you’d get the code for the chart and you could embed it into a blog or website. Now it’s gone and the alternative is pretty awful by comparison. You can’t preset the motion chart settings – well you can try – but they aren’t saved with the worksheet and you can’t configure it and then put it on your website or blog. The chart keeps reverting to the default settings making it a whole lot less useful than it used to be.

google docs google drive motion chart gadget Google Kills Spreadsheet Gadgets

 This and other old Gadgets either don’t exist in Google Drive or they have a really reduced functionality. 

Don’t get me started on the Map Gadget

Please don’t ask me about this one. This is so totally totally sad! The map gadget let you type a series of addresses into a Google Drive spreadsheet and you could select them and add the map gadget and it would plot the locations on a map.

It was A W E S O M E. And you know what? Google killed it – D E A D.

There is no map gadget – not even one which works horribly(like the other charts that replace deprecated gadgets) – it’s all gone. The only saving grace is that some folks have created apps to fill the gap and MapAList.com does a good job of taking the data from a Google Drive spreadsheet and plotting it on a map. Only I wish I didn’t have to use it – the old Google Gadget was a heap easier to use. To help you get started with MapAList I created a Youtube video that goes through the process.

This is why I hate the cloud

Yep.. there are things I hate about the cloud. Before the cloud took over our lives we bought software and it worked. If a developer made a new version of the software with new features – of if they removed old ones, we  could decide to upgrade or not.

The  cloud changed all that. Now Google makes changes and not only can we not do what we want to do but things we made don’t work anymore. The map gadget is being deprecated – for that read folks who used it in the past will find their published maps won’t work in the future. Don’t you hate that?

So what other bad news is there?

Sadly there is a lot. Google not only killed gadgets but it made a half hearted attempt at mollifying us with some new charts. Problem is that they suck – really, in contrast to what we had, they are pretty awful. They don’t have headings – so you can’t add a heading to charts like the motion chart, table chart, organization chart etc.  So, if you post a chart to your blog you’ll have to find another way to title it – really! Table charts used to be able to filter data – now they can’t – the list goes on.

google docs google drive organization chart gadget Google Kills Spreadsheet Gadgets
This is the new Organization chart – it is horrible, no title, buttons that don’t work and limited customization options – Shame Google Shame!

So, what can you do?

Bellyache about them – like I am.

Realize that all those blog posts out there that talk about Google Docs Gadgets are now wildly out of date – they are mostly useless as the charts don’t work like they use to.

Learn JavaScript – Google has a developer tool that you can use to make charts for web pages – but it is all done using JavaScript and the instructions and the examples on the Google site lack any real detail so, unless you really know what you are doing – they are hard to follow. Expect to put in a lot of trial and error to get it all working – and, to add insult to injury, you have to test your code online – the scripts won’t work on a local machine.

Hope someone creates better solutions. The folks at MapAList.com have done a good job of simplifying map creation. Hopefully other developers will create solutions that give us the functionality that Google saw fit to remove.

Stop talking about the cloud as being the panacea of all ills – it too often sucks and it disadvantages users when companies like Google take away functionality from their products.

OK.. rant over..

 

… for now  ;)

 

Helen Bradley

Thursday, November 28th, 2013

Word tables – one click insert

insert a table in word with a click 4 Word tables   one click insert

Learn to insert a table in a Word document with a single click

When you need to repeatedly create the same type of table in a Word document you can do so using the new Word Quick Part feature.

This technique works well when you use the same table layout repeatedly. Your inserted table will be the same size, have the same number of columns and rows and contain any preset formatting that it had when you created it as a Quick Part entry. Once created, you can insert it quickly whenever you need it.

To do this:

  1. Create a new table with the number of rows and columns you want all your tables to have.
  2. Include any text in the table that needs to always be in this type of table – if there is none, leave the cells blank.
  3. Format the cells in the way you wan them to be formatted every time – including text formats and cell background colors and borders.

When you are done, select the table by clicking in it and choose Table Tools > Layout > Select > Select Table.

insert a table in word with a click 1 Word tables   one click insert

Choose Insert > Quick Parts > AutoText > Save Selection to AutoText Gallery.

insert a table in word with a click 1a Word tables   one click insert

In the Create New Building block dialog set the Gallery to Tables and type a description of the table and click Ok.

insert a table in word with a click 2 Word tables   one click insert

In future, to create a table to these exact specifications choose Insert > Tables > Quick Tables, locate the table in the list and click it to insert it into the document.

insert a table in word with a click 4 Word tables   one click insert

This feature is the successor to the AutoText feature in earlier versions of Word. It looks a little more cumbersome but it is more easily discovered so you don’t have to  remember where the table was saved as it appears automatically on the Insert Table menu.

Helen Bradley

Monday, November 25th, 2013

Cometdocs – A smarter file converting tool

cometdocs Cometdocs   A smarter file converting tool

Learn how to convert files directly from Dropbox and Google Drive

Needing to converted a document from one file type into another is very common today, which is why online file conversion services have become so popular. One service that has made a name for itself by offering free high-quality file conversion capabilities is Cometdocs. Cometdocs is a document management service that also offers cloud storage and file transfer options, the website is still primarily used by people who need fast and accurate file conversion online.

The service has unveiled a bunch of updates recently, one of them being integration with popular cloud storage services such as Dropbox and Google Drive. Even though Cometdocs offers free storage to its users (2GB worth), there is no denying that there are many much more popular cloud storage competitors out there.

Thanks to this new update, Cometdocs users can convert files directly from their Google Drive or Dropbox accounts in two different ways – via their browser or using Cometdocs’ new desktop app.

Of course, in both instances you need to sign up for a free Cometdocs account first. Once you have signed up and logged in, here’s how to integrate Google Drive and Dropbox with the online service.

Right at the top of Cometdocs’ online interface, you will see a button that says “Import file from.” Click on that button and choose to synch either Dropbox or Google Drive with Cometdocs.

online+cometdocs+1 e1385387965958 Cometdocs   A smarter file converting tool 

Once the synch has been completed, a window will open up listing all of your Dropbox or Drive files. Click on the file you want converted and then click “Choose.”

online+cometdocs+2 e1385388177684 Cometdocs   A smarter file converting tool

The file is now sent to your Cometdocs clipboard from where you can drag it to the Convert tab and choose your conversion option. Cometdocs allows users to convert PDFs into a large number of different file formats including MS Excel, Word, PowerPoint, HTML, Text, AutoCAD formats and more. You can also convert these files types and more into PDF with Cometdocs. It’s safe to say that the conversion options are plentiful.

online+cometdocs+3 e1385388147237 Cometdocs   A smarter file converting tool

 

online+cometdocs+4 e1385388122988 Cometdocs   A smarter file converting tool

Integrating Cometdocs with your favorite cloud storage service is even easier when using the desktop app. Once you have downloaded and installed the app and you have signed in to your Cometdocs account through it, the conversion process can be completed in just one step.

Simple open your cloud storage folder of choice. When using the desktop app, you are no longer limited to Google Drive and Dropbox integration. You can open up the folder of any cloud service you prefer to use.

Now simply right-click on the file that you want to convert. Find the Cometdocs logo in the menu and select your conversion type.

desktop+cometdocs+1 e1385388078547 Cometdocs   A smarter file converting tool

And that’s all there is to it. The app sends the file off to Cometdocs’ server for conversion, and once the process is complete, the newly converted file is downloaded automatically into your cloud storage folder and synched.

desktop+cometdocs+2 e1385388410848 Cometdocs   A smarter file converting tool

If you are looking for a faster and easier way to convert files from within your cloud storage conveniently, Cometdocs’ integration features are hard to beat.

Go to: http://www.cometdocs.com/  or http://www.cometdocs.com/desktopApp

 

Helen Bradley

Wednesday, November 20th, 2013

Force Chrome to refresh a page

force chrome to reload a page and images 3 Force Chrome to refresh a page

How to Make Chrome display your new web page content without emptying your cache

I use Dreamweaver for my sites and Chrome as my preferred browser but I came close to throwing Chrome out the window these last few days.

You see, Chrome doesn’t like updating your pages which means that if you’re revamping pages as I have been it is perilously slow in delivering the new content to you. In fact, today I checked out a page I edited 4 days ago and while the text is up to date the images were not.

Trying the regular keyboard shortcuts just didn’t work – any key with F5 such as Shift + F5, Control + F5, the reload button Shift + R etc, etc.. I tried them all and nothing works.

I don’t particularly want to have to empty my cache to see the new content – it’s like throwing out a heap of good stuff just to display a page – it shouldn’t have to be done. This browser should work better!

Turns out it does…

….when you know how!

So here’s 2 ways to force Chrome to refresh a page:

1  Click on the page and press Control + Shift + I to display the Developer Tools.  Now, instead of clicking the button to the left of the address bar – right click it to open the menu. Choose Hard Reload – that should ignore the contents of the cache and reload page content and images from the server. This menu only appears if DevTools are enabled.

force chrome to reload a page and images 3 Force Chrome to refresh a page

If that doesn’t work:-

2  Go to the DevTools panel at the foot of the screen and, in the bottom right corner, locate Settings (the gear icon) and click it.

force chrome to reload a page and images 2 Force Chrome to refresh a page

Now check the  Disable Cache (while DevTools is open) checkbox and reload the page – voila! too easy! Yeah… your page appears.

force chrome to reload a page and images Force Chrome to refresh a page

Leave the panel open while you work.

Close it when you’re done.

There… you knew there was a secret to it – and now you’re in on it, but please, don’t keep it to yourself – spread it around, tweet it, share it!

 

 

Helen Bradley

Friday, November 15th, 2013

Google Drive Spreadsheet Notifications

notifications1 Google Drive Spreadsheet Notifications

Google Drive’s spreadsheets are liable to be shared and edited by many people.

This can potentially compromise the integrity of their data, so it’s a good idea to keep track of the changes made. Fortunately, Google provides a notifications service so the spreadsheet’s owner can do just that.

To access the notification rules, open the spreadsheet you want to track and select Tools > Notification Rules…. The resulting dialogue allows you to choose what changes to track. If only some data is critical, you can choose to only track a specific sheet or cell range. If you’ve set up a form to feed its result into your spreadsheet, you can choose to be notified whenever somebody submits the form. Choosing email – daily digest will add the notification to a daily email that contains all of your notifications that have this rule selected. Email - right away immediately sends the specific notification to you.

Click Save when you are done. Your new notification rule will be the first on a list of all the notification rules for that spreadsheet. From the list you can add new rules, or edit or delete an existing one.

Helen Bradley

Page 1 of 3612345102030Last »