Posted by jpluimers on 2013/03/04
Question: How do you make Excel print those cell lines?
Thanks seb32:
I’m assuming you want to print the grid…
- File menu,
- Page Setup,
- go to the Sheet tab,
- On that page, under Print, there’s a checkbox called “Gridlines”.
Note: the above is for Excel 2003; Print Gridlines in Excel shows that Excel 2007 and 2010 have slightly different settings.
–jeroen
via:
Posted in Excel, Office, Power User | Leave a Comment »
Posted by jpluimers on 2013/02/15
A while ago, I salvaged the Windows Mail *.eml files from a broken Vista machine of a friend to a new machine running Outlook. The Vista machine was so broken that it wouldn’t boot any more (now he knows that porn comes with truckloads of viruses).
Naively I assumed this was a straightforward process (hey, it’s all Microsoft, and they have great interoperability, right?).
Well no (:
So as soon as you have all mail in Windows Mail, then you can export it to Outlook.
You can do the same with *.dbx files from Outlook Express: use Windows Mail as an intermediate store as described here: Importing DBX files into Outlook 2007 – Windows Software.
But first things first.
Posted in Office, Office 2003, Office 2007, Office 2010, Office 2013, Outlook, Power User | Leave a Comment »
Posted by jpluimers on 2013/01/28
A quick and easy way of getting the CurrentCulture and CurrentUICulture is to use the get-host cmdlet from PowerShell.
This is what PowerShell 2.0 shows on my system:
C:\Users\jeroenp>powershell get-host Name : ConsoleHost Version : 2.0 InstanceId : 1ce173fb-70a7-403b-a2bd-3800fe740f7c UI : System.Management.Automation.Internal.Host.InternalHostUserInterface CurrentCulture : en-IE CurrentUICulture : en-US PrivateData : Microsoft.PowerShell.ConsoleHost+ConsoleColorProxy IsRunspacePushed : False Runspace : System.Management.Automation.Runspaces.LocalRunspace
The SeaTools from Seagate can’t cope with that because they don’t manage the Resource Fallback Process properly.
My machine is on en-IE, as it is English, and USA as location.
The main advantage for me is to use the that it is a good mix between English and Dutch settings:
–jeroen
via: Get-Host.
Posted in .NET, CSV, Development, Excel, ISO 8601, Office, Power User, PowerShell, Scripting, Software Development | Leave a Comment »
Posted by jpluimers on 2013/01/17
Last year, I missed this tiny sentence:
So in plain English, any VM that was generated on VMware ESX Server 3.5 or later can run atop ESXi 5.1 unchanged.
Which means it is a snap to move your VMs from older ESX / ESXi / vSphere versions as long as they are ESX 3.x or later.
In fact hardware version 7 has the widest compatibility amongst ESX/ESXi/vSphere/Fusion/Workstation/Player versions (see the table at the bottom).
The free version still has a 32 gigabyte physical RAM limit (people are still confused by the vRAM / Physical RAM distinction, especially since vRAM is not limited any more). Read the rest of this entry »
Posted in ESXi4, ESXi5, ESXi5.1, Excel, Fusion, Power User, VMware, VMware ESXi, VMware Workstation, Word | Tagged: computer, hardware version, hardware versions, machine hardware, physical ram, software, technology, version compatibility, virtual hardware, virtual machine, virtual machines, vm, vms | Leave a Comment »
Posted by jpluimers on 2013/01/17
Every once in a while, Office Communicator indicates a contact is not off-line and allows me to send messages to him/her, but then gives an error 504.
The reason is that the off-line status replicates slowly, so you were not aware your contact went off-line while typing the message.
The Error ID 504 is just an unfrienly way of saying “your contact went off-line, but you didn’t know that when sending the message, and I don’t have a friendly way of telling you this”.
–jeroen
via: Communicator 2007 R2 Help on Error ID 504.
Posted in Communicator, Office, Power User, Windows, Windows 7, Windows XP | Leave a Comment »
Posted by jpluimers on 2012/12/28
One thing I always forget (especially since the UI in Office 2007 changed quite a bit, but the idea below gets me going).
I’m assuming you want to print the grid…
- File > Page Setup,
- then go to the Sheet tab.
- On that page, under Print, there’s a checkbox called “Gridlines”.
–jeroen
via How do you make Excel print those cell lines? – AfterDawn: Forums.
Posted in Excel, Office, Power User | Leave a Comment »
Posted by jpluimers on 2012/11/30
In Excel I always got confused with named ranges, as I thought they were hard to track.
Not!
The F3 keyboard shortcut gives you a list of named ranges including name and location. Which makes it way easier to work with named ranges.
See the excellent post Show all named ranges in Excel: It even has an animated gif image that shows you F3 in action.
–jeroen
Posted in Excel, Keyboards and Keyboard Shortcuts, Office, Power User | Leave a Comment »
Posted by jpluimers on 2012/09/17
Learned a few Excel keyboard shortcut pairs today:
| Shortcut | Action |
|---|---|
| Ctrl+Spacebar | Select columns |
| Shift+Spacebar | Select rows |
| Ctrl+; | Current date |
| Ctrl+Shift+: | Current time |
| Ctrl+Shift+2 | Format current cell as default date |
| Ctrl+Shift+3 | Format current cell as default time |
–jeroen
via:
Posted in Excel, Keyboards and Keyboard Shortcuts, Office, Power User | Leave a Comment »
Posted by jpluimers on 2012/09/06
The problem with localized error messages often is that it is virtually impossible to find information about them.
For instance the below error got reported by a client for me to fix (click on the picture to get a larger version) has a few big problems:
Posted in Excel, Office, Power User, Windows | Tagged: ctrl c, english versions, error messages, file formats, google, message box, microsoft com downloads, microsoft office online, office excel, office microsoft, pleonasm, software, technology, zero results | 2 Comments »
Posted by jpluimers on 2012/09/04
I had a function like this in Excel:
=IF(OR(B2=""; SEARCH(C2;B2)); "ok"; "INCONSISTENT")
The situation should be OK when either:
B2 is empty (an empty cell is considered equal to a zero length string).C2 can be found in the value of cell B2Since most of my software development is outside of Excel, I’m used to short-circuit boolean evaluation.
Not with Excel: the OR is a function, not an operator, so all other function calls will be evaluated.
Since SEARCH will return #VALUE! when the first argument does not have a value, and #VALUE! propagates in a similar way as NULL in SQL does (SQL has the Boolean datatype inconsistency though).
So you need to get rid of #VALUE! as soon as you can using the one of the IS functions like the ISERROR function or the ISNUMBER function.
ISNUMBER, contrary to popular belief, not only distinguishes numbers from text, but in fact from any non-numeric value as Glaswegian kindly explained on the TechSupport forum:
Excel IF and SEARCH function combination
I am trying to do the following:
If cell A1 contains the characters “ABC” anywhere in the string or value, then “Y”, else “N”. I almost have it by using =if((search(“ABC”,A1)),”Y”,”N”). However, with the “else” if “ABC” is not found, it returns #VALUE! as opposed to “N”.
[…]
Try
=IF(ISNUMBER(SEARCH("abc",A1,1)),"Y","N")ISNUMBER checks the type of value and returns TRUE or FALSE. The #VALUE error refers to the fact that Excel could not translate the value to the type required.
So the code ends up as this:
=IF(OR(B2=""; ISNUMBER(SEARCH(C2;B2))); "ok"; "INCONSISTENT")
–jeroen
via: Excel IF and SEARCH function combination – Tech Support Forum.
Posted in Development, Excel, Office, Power User, Software Development | Leave a Comment »
The Wiert Corner - irregular stream of stuff 