Insert Custom Number Of Rows In Excel With This Simple Macro

macro_excel
The MS Office apps are designed very intelligently and I'm not saying this just because they make my work infinitely easier. I'm saying it because its true. A few days back we did a post on inserting YouTube videos in Office 2013 and noted that the option was absent in MS Excel simply because it wasn't needed there. This is the type of intelligence I'm talking about; knowing which features are needed in a specific type of app. It makes sure nothing irrelevant makes it into the final offering. That said, I was surprised to find that where Excel allows you to insert more rows in a worksheet, it doesn't let you select the number of rows you want to add. You have other work arounds for accomplishing this like selecting the number of rows you want add from the existing ones and then using the insert function. Or you could repeat the insert row step for as many rows as you want. It is repetitive but if you're willing to spare five minutes, this little Macro can take care of the job for you. Read More

Prevent Others From Editing Important Parts Of A Shared Word File

Prevent-editing-banner
Often times, working on a documentation task in groups can result in confusion. Unless you've made absolutely certain that no one is going to attempt to edit a section they are not supposed to edit, it's going to be hard to keep the essential bits of the document unchanged. Fortunately, MS Word has for a long time supported a great tool called Content Control which allows the author of a document to prevent others from editing any part of it. It's as simple as selecting the text which may be the literature review, concluding remarks, the index, or anything similar that took a great deal of work to put together, and then applying a simple control to it. The only tricky bit is knowing where to look for that control. Read More

How To Start A Conversation With Firefox Hello

FF_hello_call
Firefox 34 was released just a short while back and where it wasn't big on features in terms of numbers, there was one huge feature that was introduced in the release; Firefox Hello. Think about Google Hangouts; a chat service that is restricted to your Gmail account and the Chrome browser. Remove those restrictions and you have Firefox Hello. You are restricted to needing Firefox to initiate a conversation but neither you nor your recipient need a Firefox account and they also don't need to use Firefox. Here's how you can start either an audio call or a video call with Firefox Hello. Read More

Windows Hidden Steps Recorder Turns Screen Action Into Step-By-Step Instructions

PSR
Have you ever tried to explain a process to someone, had to write out instructions, or receive instructions or steps for using a particular software or reproducing a bug from someone who isn't very good at reporting them? The simplest way around problems like this are screencasts. You can create one to use as an instruction medium, or you can ask someone to make one and send it to you so you can see what steps were taken to result in a bug. Not everyone is comfortable with screencasting tools, even the simplest ones and just getting the instruction for downloading the right kind of software to the person you're trying to help might be a problem. Fortunately, Windows has a built-in tool called Problems Steps Recorder that records your on-screen actions and converts them into text-based instructions. You run the app, hit record, and execute the steps you want to explain or that are resulting in an error of some sort. Once you're done, you only have to send the output file to the recipient. The app is present in both Windows 7 and Windows 8. Read More

Begin Projects by Creating An Outline & Organizing Your Content

Foldout_outlines
Getting started on a project or report, academic or work related seems daunting. There are so many things that should be included but at the same time, the information needs to come together in just the right way to make sense. There's two approaches you can take to it; you can gather the information first, and arrange it later. Alternatively, you can start with an outline so you don't spend too much time looking for information you won't need. Foldout is a very simple Windows tool that lets you create outlines for a project. It's a great way to get organized whenever you're documenting anything new and the app lets you export your outline to HTML, DOCX, and TXT format. Read More

Inserting & Embedding YouTube Videos In MS Office 2013

MS_Office_Video
Going from Office 2003 to Office 2007, the only thing that popped out at me was the annoying format problem. It was a plague for me because I was still studying at the time and project documentation in a group became a problem. With Office 2013 though I was seriously excited because it offered some truly amazing new features, my favorite of which is the 'pick-up where you left off' feature in MS Word. Office 2013 also makes it ridiculously simple to insert online videos in both Word documents and PowerPoint presentations. The revamped insert video feature lets you embed a YouTube video, and even search for one from without ever leaving the application. Here's a quick guide to doing just that. Read More

3 Great Ways To Use The Count Function In Excel

count_function
Excel is a truly amazing app that's helped countless people analyse and manipulate large sets of data. In my opinion, it is a great tool that can find some sort of utilization in just about any field (except maybe oil rigs). A short while back we did a post on five Excel functions that can be exceptionally useful in making mundane, boring, repetitive work considerably easier. Many of us, specially those doing managerial or administrative tasks on a daily basis grow quite familiar with many of the functions that Excel supports and while we may know how to use one, where to use it and how a function can make life easier isn't always so obvious. Today I'm detailing three uses of the very simple 'Count' function in Excel. Read More

New Features In Firefox 34 For Desktop And Android

ff34-banner
Firefox 34 is now available. If the update hasn't already downloaded, go ahead and check for it now. Firefox 34 is leaning more on the end-user side in terms of new features. The Android version isn't big on either developer or end-user features with Chromecast mirroring being the only significant one. The most interesting feature in Fiefox 34 is easily Firefox Hello, a new way to exchange private messages, both audio and video though the feature is still in its Beta phase. Other significant features are the new theme switcher and a way to fix the 'Fire. fox is already running' problem that users encounter at times. Read More

Equalizer Frequencies & Settings On Music Players Explained

equalizer
The best music players have music equalizer settings and  come with pre-sets to make the music you're listening to sound really good. These pre-sets are defined by the genre they're best suited for such as pop or rock (but never with a goth metal satanic screaming pre-set for some reason). But what are these mystery settings that claim to improve our listening experience? Are they even real or is it just something developers the world over have collectively conspired to add to music players for the sake of looking cool? The equalizer settings are 100% legit as is the claim that the right setting will improve the quality of music you hear, subject to what kind of speakers you have. We're going to take a look at what the equalizer is and just what each of those sliders mean. Read More

Get Alerts When Your Laptop Battery Is Low Or Full [Windows]

windows low battery level
I had a spot of trouble with my laptop these past few days. Now that it's been repaired, I have to keep a very close eye on how much the battery is charged. Before this happened, all I ever needed to care about was if my battery was plugged in and charging. Since it hadn't bothered me in the past (and this is about 4 years worth of past), I really had zero ideas as to how to monitor battery percentage levels without expanding too much effort. There was the obvious risk that I'd just forget to check how much charge my battery had left, or how full it was. Fortunately, both problems were solved by using a script, and some built-in battery checks that Windows has. You can use both to get on-screen and audio alerts for when your battery has charged up to a certain level and it works for when you want to set a limit to the minimum or maximum charge.

Read More

Find Easy Thanksgiving Recipes With These Apps & Websites

thanksgivnig-banner
Thanksgiving is only a day away and while there is much debate on whether or not major retail stores should be open on Black Friday, one thing is for certain; there will be lots of food. Normally, we can cut as many corners as we want when it comes to everyday cooking for our personal sustenance but on a holiday, one that food is a major part of, a lot of people like doing a little something extra for a better meal. For experienced cooks, this might mean phoning up grand-ma and asking her for the recipe to her secret sauce, trying a new stuffing for the bird, or just experimenting with something completely new. For the novice cook, this might mean a nervous breakdown as they try and figure out what groceries to buy. Regardless of what your expertise is, we have a list of resources for both seasoned (pun intended) and novice cooks to help you eat better this Thanksgiving. Read More

OneDrive Integration In Windows 10; Everything You Need To Know

one-drive
No doubt you've heard that Windows 10 will feature deeper OneDrive integration. Microsoft pushed its cloud drive onto it users back in Windows 8 and with each successive build of the Windows 10 technical preview, we see how more features are going to look and behave in the final version. OneDrive has some new settings in place, you still can't turn the thing off completely, and it's gone the Dropbox way of syncing files after listening to feedback from users who weren't all too happy with how the desktop app worked in Windows 8. Here's a quick look at OneDrive for Windows 10. Read More

4 Visual Changes In The New Windows 10 Technical Preview Build

folder icons
Microsoft has released Build 9879 of the Windows 10 Technical preview and it's actually more buggy than the last one. As it was with Build 9860, some features originally revealed at the official unveiling of Windows 10 but not released immediately, have been enabled with this new build. Windows 10 is also under going what can best be described as an interface change though the changes are far less extreme and really just a reinforcement of the Modern UI. Four UI changes caught our eye are the new folder icons, the battery indicator on both the lock screen and in the system tray, the new hamburger style buttons on Modern apps, and the refined look of the Notification Center. Read More

5 Basic Excel Functions That Make Work Infinitely Easier

autofill series
Excel is the illiterate man's (and woman's) favorite data manipulation tool. The literate i.e. those that can code, don't need to worry themselves much about columns, rows, and the correct formula and its syntax because these wizards have their own devices. For everyone else, practically anyone in a management position, Excel is an essential work tool. Despite this, a lot of people, especially those just stepping into a job are often intimidated by it. In reality, if you learn Excel well enough, you can use it to keep time based records that update automatically, use it to store inventory, and even conduct surveys. That said, here are five very basic Excel functions that every beginner needs to know. Read More

How To View And Delete Cookies In Firefox Developer Edition

ff Dev del cookie
Firefox has always been the go-to browser for developers. This preference comes as a result of Mozilla always considering the needs of developers as well as end users with each iteration of its browser. The company makes it a priority to provide the best development tools and in that endeavor, they recently launched the Firefox Developer Edition. This browser, in Mozilla's own words, is a browser for developers made by developers. It features amazing tools and needless to say, it isn't intended for the average user though developers can rely on it to work as a reliable browser when/if needed. Where the Firefox Developer Edition is somewhat familiar in the tools it provides, it's going to take some time to grow familiar with it all. If you've started using it you might have found that there isn't an obvious way to delete cookies. This post explains how you can view, edit, and delete cookies in Firefox Developer Edition. Read More

Everything You Need To Know About The Windows 10 Notification Center

notifications panel
Notifications have been a part of the Windows OS for a good long time though up until Windows 8, they weren't even in the same league as those on OS X or even on our smartphones. Windows 10 refines them further so that you can review all notifications you've received in a single pop-up panel. The notifications can be turned off or muted on a per-app basis, or you can mute all notifications for a certain period of time. The notifications are interactive; if you save a new file, or download an app, clicking the notification that alerts you to the completion of either of those actions will open the file, or launch the app for you. Here is a quick run down of everything you can do with the new Windows 10 notification center. Read More

TakeOwnerShip Pro: Resolve ‘Cannot Delete’ And ‘Access Denied’ Errors [Windows]

take ownership pro
File and folder permissions on Windows are pretty great when they're working for you but when the OS suddenly decides to deny access to a folder on your hard drive even though you're logged in as the administrator, these very permissions become a problem, to say the least. You end up jumping through hoops trying to figure out why a file you created a short while back is no longer accessible to you. We've reviewed a number of utilities that help fix the 'Cannot Delete File' and 'Access Denied' errors, noteworthy of which is Unlocker. A new app in this same category is TakeOwnerShip Pro; it has a super simple interface and is compatible with all Windows versions from Vista to Windows 10. Read More

Windows 10 Virtual Desktop Shortcuts

select-next-previous-desktop
Following up on our post about Windows 10 shortcuts for snapping windows, we decided to explore one of the more exciting features in Windows 10, the virtual desktops. Windows is great when it comes to keyboard shortcuts so rest assured if someone were to go out hunting for a list of shortcuts for any feature, they won't be disappointed. So far as the Technical Preview of Windows 10 is concerned, we've found four helpful shortcuts that let you switch to the next or previous desktop from the current one, close a virtual desktop, open a new virtual desktop, or select the next or previous desktop when you have the multi-task view open. Read More

How To Snap Windows Using Keyboard Shortcuts In Windows 10

snap-windows-3
Snapping in Windows 10 is very different than it was in Windows 8 and Windows 7. If you never made the jump to Windows 8, or if you decided to revert back to Windows 7 after you realized you didn't like Windows 8 one bit, snapping windows in Windows 10 will seem even more different. We touched on the feature, and how it works in our Windows 10 feature review. One major change with the Snap feature is that it doesn't just let you snap windows to one half or one quarter of the screen. Instead you have many more snapping options and more sizes to snap a window in. This guide details them all. Read More

Hiding The Mini Toolbar In Office 2013

Word Options
Microsoft got a lot of heat with Windows 8 and loyal Windows users were disappointed with the company's attempt at innovation since it ended up sacrificing two of the most iconic features of the OS but Microsoft and its products aren't all a result of trial and error. Take a look at Office 2013 and you can see the company gets a lot of things right in just the one go. The Office productivity suite has everything you could ever need to make a solid well-formatted document, spreadsheet, or presentation. What's more is that it also features many auto-fill options and helpful pop-ups to make formatting and composing a document or presentation easier. That said, one of the chief annoyances is the Mini Toolbar that pops up in all office apps when you select text. For some, this might be helpful but it appears over the text and there isn't an easy way to dismiss it. You can  however, disable it, if it annoys you. Here's how. Read More